SELECT
count(DISTINCT ruc.user_id) as ypeople,
count(DISTINCT Case WHEN exam_result='103002' THEN ruc.user_id END) as ppeople,
count(DISTINCT Case WHEN exam_result='103001' THEN ruc.user_id END) as fpeople,
count(DISTINCT Case WHEN exam_result IS NULL AND exam_scores IS NULL THEN ruc.user_id END) as fpeople
FROM
record_user_course ruc
LEFT JOIN user_organization_lms uol ON ruc.user_id = uol.user_id
LEFT JOIN organization org ON uol.org_id = org.id
WHERE
1 = 1
AND course_id IN (
'5aa94f93-34dc-49e9-96d1-80ce6716fcf1'
)
AND ruc.train_plan_id = '81d51d2bf5744e41be4604c22b34defe'
AND ruc.platform_id = '3'
AND org.path LIKE CONCAT('-3_1-', '%') limit 0,1
count(DISTINCT ruc.user_id) as ypeople,
count(DISTINCT Case WHEN exam_result='103002' THEN ruc.user_id END) as ppeople,
count(DISTINCT Case WHEN exam_result='103001' THEN ruc.user_id END) as fpeople,
count(DISTINCT Case WHEN exam_result IS NULL AND exam_scores IS NULL THEN ruc.user_id END) as fpeople
FROM
record_user_course ruc
LEFT JOIN user_organization_lms uol ON ruc.user_id = uol.user_id
LEFT JOIN organization org ON uol.org_id = org.id
WHERE
1 = 1
AND course_id IN (
'5aa94f93-34dc-49e9-96d1-80ce6716fcf1'
)
AND ruc.train_plan_id = '81d51d2bf5744e41be4604c22b34defe'
AND ruc.platform_id = '3'
AND org.path LIKE CONCAT('-3_1-', '%') limit 0,1