select sum( case when b.`code2` = 1 then 1 END ) as "未解決" ,sum( case when b.`code2` = 2 then 1 END ) as "解決中" ,sum( case when b.`code2` = 3 then 1 END ) as "解決" from anken a left join jokyo b on a.`id` = b.`ankenid` where b.`code1`…