query หมอโอ

SELECT
COUNT(DISTINCT CASE WHEN FLOOR(DATEDIFF(o.vstdate, p.birthday) / 365.25) BETWEEN 15 AND 39 THEN o.hn ELSE NULL END) AS count_people_15_39_years,
COUNT(DISTINCT CASE WHEN FLOOR(DATEDIFF(o.vstdate, p.birthday) / 365.25) >= 40 THEN o.hn ELSE NULL END) AS count_people_40_plus_years
FROM
ovst o
LEFT JOIN
patient p ON o.hn = p.hn
WHERE
o.vstdate BETWEEN '2024-09-01' AND '2025-06-30'
AND o.spclty = '11'