หัตถการ IPD

SET @d1 = 20250701;
SET @d2 = CURDATE();
SELECT LEFT
 ( @d2, 4 )+ 543 AS ปีงบประมาณ,
 SUM( CASE WHEN io.icd9 = 9960 THEN 1 ELSE 0 END ) AS 9960_Cpr,
 SUM( CASE WHEN io.icd9 = 9604 THEN 1 ELSE 0 END ) AS 9604_Ettube,
 SUM( CASE WHEN io.icd9 = 9962 THEN 1 ELSE 0 END ) AS 9962_Defib,
 SUM( CASE WHEN io.icd9 = 3404 THEN 1 ELSE 0 END ) AS 3404_Icd
FROM
 iptoprt io INNER JOIN ipt i on i.an=io.an
WHERE
 i.regdate BETWEEN @d1
 AND @d2