query รับวัคซีนพิษสุนัขบ้า

SELECT
COUNT(DISTINCT ovst.hn) AS 'HN',
COUNT(DISTINCT ovst.vn) AS 'Visit'
 
FROM
  ovst
  INNER JOIN ovstdiag dx ON dx.vn = ovst.vn
    INNER JOIN kskdepartment dep ON ovst.main_dep = dep.depcode
WHERE
  ovst.vstdate BETWEEN '2023-10-01' AND '2024-09-30'
  AND dx.icd10 IN ('Z242','W540')
    AND dep.department LIKE '%ฉุกเฉิน%'
--   AND ovst.main_dep = '004'