select h.hoscode hospcode,cast(h.hosname as char(200)) hospname,count(*) target,sum(result="Y") result,sum(result="Y")/count(*)*100 percent from chospital_amp h left join ( select p.hospcode,p.cid,p.hn,p.pid,concat(p.name," ",p.lname) ptname ,group_concat(distinct if(cc.pid is not null,"Y",null)) result from person p left join chronic c on c.pid=p.pid and c.hospcode=p.hospcode and c.chronic between "E10" and "E1499" and c.date_diag<"2015-04-01" left join chronic cc on cc.pid=p.pid and cc.hospcode=p.hospcode and cc.chronic between "E10" and "E1499" and cc.date_diag>="2015-04-01" where timestampdiff(year,p.birth,"2015-04-01")>=35 and p.typearea in (1,3) and p.discharge = "9" and c.pid is null group by p.hospcode,p.pid ) a on a.hospcode=h.hoscode group by a.hospcode union select "ภาพรวมทั้งคัพ" as hoscode,"" as hosname,count(*) target,sum(result="Y") result,sum(result="Y")/count(*)*100 percent from chospital_amp h left join ( select p.hospcode,p.cid,p.hn,p.pid,concat(p.name," ",p.lname) ptname ,group_concat(distinct if(cc.pid is not null,"Y",null)) result from person p left join chronic c on c.pid=p.pid and c.hospcode=p.hospcode and c.chronic between "E10" and "E1499" and c.date_diag<"2015-04-01" left join chronic cc on cc.pid=p.pid and cc.hospcode=p.hospcode and cc.chronic between "E10" and "E1499" and cc.date_diag>="2015-04-01" where timestampdiff(year,p.birth,"2015-04-01")>=35 and p.typearea in (1,3) and p.discharge = "9" and c.pid is null group by p.hospcode,p.pid ) a on a.hospcode=h.hoscode