รายงานแสดงจำนวนหญิงตั้งครรภ์ จำแนกตามระดับการศึกษา

SELECT cha.changwatname,        
  SUM(
	IFNULL( s.`edu_01`, 0 )) AS sumedu01,
	SUM(
	IFNULL( s.`edu_02`, 0 )) AS sumedu02,
	SUM(
	IFNULL( s.`edu_03`, 0 )) AS sumedu03,
	SUM(
	IFNULL( s.`edu_04`, 0 )) AS sumedu04,
	SUM(
	IFNULL( s.`edu_05`, 0 )) AS sumedu05,
	SUM(
	IFNULL( s.`edu_06`, 0 )) AS sumedu06,
	SUM(
	IFNULL( s.`edu_00`, 0 )) AS sumedu00 ,
	SUM(
	IFNULL( s.`edu_99`, 0 )) AS sumedu99
FROM mrisk_basedb s
	LEFT JOIN hdc.chospital ch ON ch.hoscode = s.hospcode
	LEFT JOIN hdc.campur ca ON ca.ampurcodefull = CONCAT( ch.provcode, ch.distcode )
	LEFT JOIN hdc.cchangwat cha ON cha.changwatcode = CONCAT( ch.provcode ) 
where 1=1  and cha.zonecode = '12'  group by cha.changwatcode;