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…