SELECT d.changwatname as name,e.all_sex as person_all,e.male as person_male,e.female as person_female,count(a.PROV) death_total
,SUM(IF(a.sex=1,1,0)) as male
,SUM(IF(a.sex=2,1,0)) as female
FROM birth a
LEFT JOIN ( SELECT * FROM cchangwat WHERE zonecode = 07) d ON a.prov = d.changwatcode LEFT JOIN (SELECT * FROM pop_ampur WHERE n_year= 2567 AND provcode=44) e ON d.changwatcode = e.provcode
WHERE 1=1
AND BYEAR =2567
GROUP BY a.prov;