query หัตถการจากห้องทันตกรรม

SELECT
DISTINCT(a.hn) AS 'hn'
from dtmain a
INNER JOIN dttm b ON a.tmcode = b.code
where b.icd10tm_operation_code = 2372700
and a.vstdate BETWEEN '2024-10-01' AND '2025-09-30'

SELECT
DISTINCT(v.hn) as 'hn'
FROM hos_pt_visit v
INNER JOIN hos_pt p ON v.hn = p.hn
INNER JOIN hos_doctor_procedure pc on v.visit_code = pc.visit_code
 
WHERE v.date_visit_sql BETWEEN '20241001' AND '20250323'
AND pc.icd9 = '2381402'

SELECT
    COUNT(DISTINCT o.vn) as 'visit'
FROM
    ovst AS o
LEFT JOIN
    patient AS p ON o.hn = p.hn
LEFT JOIN
    kskdepartment AS k ON o.main_dep = k.depcode
INNER JOIN ovstdiag d ON o.vn = d.vn
 
WHERE
o.main_dep = '003'
and o.vstdate between '2024-09-01' AND '2025-10-30'
AND d.icd10 = 'L439'