query Home Ward แยกตามโรค

SELECT
    d.icd10,
    COUNT(DISTINCT i.hn) AS 'HN',
    COUNT(DISTINCT i.an) AS 'AN'
FROM
    ipt i
INNER JOIN
    iptdiag d ON i.an = d.an
LEFT JOIN
    ward w ON i.ward = w.ward
WHERE
    i.regdate BETWEEN '2023-10-01' AND '2024-09-30'
    AND w.name = 'Home Ward'
    AND d.diagtype = '1'
    AND d.icd10 NOT LIKE 'F%'
GROUP BY
    d.icd10