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`…

id name 1 anken1 2 anken2 3 anken3 id ankenid code name 1 1 1 ko1-1 2 1 2 ko1-2 3 1 3 ko1-3 4 2 2 ko2-1 5 2 3 ko2-2 6 2 5 ko2-3 id ankenid kazu 1 1 1 2 1 2 3 1 3 4 2 2 5 2 3 select a.id, min(b.code),x.q from anken a left join anken2 b on a…