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

	select  	cha.changwatname, 
	SUM(s.total_anc) as total_anc,
	SUM(s.r0) as r0,ROUND(SUM(s.r0)*100/SUM(s.total_anc),2) as p_r0,
		SUM(s.r1) as r1,ROUND(SUM(s.r1)*100/SUM(s.total_anc),2) as p_r1,
			SUM(s.r12) as r12,ROUND(SUM(s.r12)*100/SUM(s.total_anc),2) as p_r12,
				SUM(s.r13) as r13,ROUND(SUM(s.r13)*100/SUM(s.total_anc),2) as p_r13
	from 
	(
	select hospcode,
	SUM(IFNULL( typerisk0, 0 )) as r0,
	SUM(IFNULL( typerisk1, 0 )) r1,
	SUM(IFNULL( typerisk12, 0 )) r12,
	SUM(
	IFNULL( typerisk13, 0 )) r13,
	SUM(
	IFNULL( totalrisk, 0 )) total,
	SUM(
	IFNULL( totalanc, 0 )) total_anc 
FROM
	mrisk_s_type_risk s
	group by hospcode) 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
	hdc_regist = '1' 
	AND cha.zonecode = '12'  and cha.zonecode = '12'  group by cha.changwatcode;