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 ,p.birth ,group_concat(distinct if(a.vaccinetype regexp "035",a.vaccinetype,null) order by a.vaccinetype) vaccinetype ,group_concat(distinct if(a.vaccinetype regexp "035","Y",null)) result from person p left join epi a on a.pid=p.pid and a.hospcode=p.hospcode and timestampdiff(year,p.birth,a.date_serv)<=5 where p.birth between date_add("2015-04-01",interval -5 year) and date_add("2016-03-31",interval -5 year) and p.typearea in (1,3) and p.discharge = "9" 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 ,p.birth ,group_concat(distinct if(a.vaccinetype regexp "035",a.vaccinetype,null) order by a.vaccinetype) vaccinetype ,group_concat(distinct if(a.vaccinetype regexp "035","Y",null)) result from person p left join epi a on a.pid=p.pid and a.hospcode=p.hospcode and timestampdiff(year,p.birth,a.date_serv)<=5 where p.birth between date_add("2015-04-01",interval -5 year) and date_add("2016-03-31",interval -5 year) and p.typearea in (1,3) and p.discharge = "9" group by p.hospcode,p.pid ) a on a.hospcode=h.hoscode