รายงานแสดงจำนวนหญิงตั้งครรภ์ จำแนกกลุ่มอายุ

SELECT
	cha.changwatname,
	SUM(
	IFNULL( s.`<10`, 0 )) AS sumage10,
	SUM(
	IFNULL( s.`1015`, 0 )) AS sumage1019,
	SUM(
	IFNULL( s.`1619`, 0 )) AS sumage1619,
	SUM(
	IFNULL( s.`2029`, 0 )) AS sumage2029,
	SUM(
	IFNULL( s.`3039`, 0 )) AS sumage3039,
	SUM(
	IFNULL( s.`4049`, 0 )) AS sumage4049,
	SUM(
	IFNULL( s.`>50`, 0 )) AS sumage50 
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;