How to make such a SELECT from the values ​​of one column multiplied by the value of another?

Question

MySQL

There are qveri

SELECT ps_ur AS UR, COUNT(ps_ur) AS Value FROM patient_services GROUP BY UR 
UNION ALL
SELECT eng_ur AS UR, COUNT(eng_ur) AS Value  FROM engagements WHERE LENGTH( eng_ur )>0  GROUP BY UR

produces a result like

UR Value
002035 3
002400 2
005441 4

I need to count how many patients M and F I have been examined from the table with patient data

SELECT 
SUM( CASE WHEN patient_gender = 'Male' THEN 1 ELSE 0 END ) Male, 
SUM( CASE WHEN patient_gender = 'Female' THEN 1 ELSE 0 END ) Female 
FROM patients WHERE patient_ur 
//Дальше не знаю что применить IN call foreach...
//Нужно из результатов первого запроса подсчитать пол и умножить на value

how to do this?

Answer 1

SELECT 
SUM( CASE WHEN patient_gender = 'Male' THEN 1*xxx.Value ELSE 0 END ) Male, 
SUM( CASE WHEN patient_gender = 'Female' THEN 1*xxx.Value ELSE 0 END ) Female 
FROM patients JOIN (
SELECT ps_ur AS UR, COUNT(ps_ur) AS Value 
FROM patient_services 
GROUP BY UR 
UNION ALL
SELECT eng_ur AS UR, COUNT(eng_ur) AS Value  
FROM engagements 
WHERE LENGTH( eng_ur )>0  
GROUP BY UR ) xxx ON  patients.patient_ur = xxx.UR