ชุดคำสั่ง
select campur.ampurcodefull as HOSPCODE,
campur.ampurname as hosname,
SUM(CASE WHEN epi.VACCINETYPE = '010' THEN 1 ELSE '' END) AS 'BCG',
SUM(CASE WHEN epi.VACCINETYPE = '041' THEN 1 ELSE '' END) AS 'HBV1',
SUM(CASE WHEN epi.VACCINETYPE = '091' THEN 1 ELSE '' END) AS 'DTP-HBV1',
SUM(CASE WHEN epi.VACCINETYPE = '092' THEN 1 ELSE '' END) AS 'DTP-HBV2',
SUM(CASE WHEN epi.VACCINETYPE = '093' THEN 1 ELSE '' END) AS 'DTP-HBV3',
SUM(CASE WHEN epi.VACCINETYPE = '401' THEN 1 ELSE '' END) AS 'IPV-P',
SUM(CASE WHEN epi.VACCINETYPE = '081' THEN 1 ELSE '' END) AS 'OPV1',
SUM(CASE WHEN epi.VACCINETYPE = '082' THEN 1 ELSE '' END) AS 'OPV2',
SUM(CASE WHEN epi.VACCINETYPE = '083' THEN 1 ELSE '' END) AS 'OPV3',
SUM(CASE WHEN epi.VACCINETYPE = '061' THEN 1 ELSE '' END) AS 'M/MMR1',
SUM(CASE WHEN epi.VACCINETYPE = '034' THEN 1 ELSE '' END) AS 'DTP4',
SUM(CASE WHEN epi.VACCINETYPE = '084' THEN 1 ELSE '' END) AS 'OPV4',
SUM(CASE WHEN epi.VACCINETYPE = '052' THEN 1 ELSE '' END) AS 'JE1',
SUM(CASE WHEN epi.VACCINETYPE = 'J11' THEN 1 ELSE '' END) AS 'JE1_1',
SUM(CASE WHEN epi.VACCINETYPE = '053' THEN 1 ELSE '' END) AS 'JE2',
SUM(CASE WHEN epi.VACCINETYPE = 'J12' THEN 1 ELSE '' END) AS 'JE2_2',
SUM(CASE WHEN epi.VACCINETYPE = '073' THEN 1 ELSE '' END) AS 'MMR2',
SUM(CASE WHEN epi.VACCINETYPE = '035' THEN 1 ELSE '' END) AS 'DTP5',
SUM(CASE WHEN epi.VACCINETYPE = '085' THEN 1 ELSE '' END) AS 'OPV5'
FROM epi
INNER JOIN person ON epi.HOSPCODE = person.HOSPCODE and epi.PID = person.PID
inner join chospital on epi.HOSPCODE = chospital.hoscode
INNER JOIN campur ON chospital.distcode = campur.ampurcode
where epi.date_serv BETWEEN 0 and 0 AND campur.changwatcode = '77'
AND person.NATION <> '099'
group by distcode