回答編集履歴
1
抜けを修正
answer
CHANGED
|
@@ -6,6 +6,7 @@
|
|
|
6
6
|
FROM ken AS K
|
|
7
7
|
LEFT OUTER JOIN member AS M
|
|
8
8
|
ON K.ken_id = M.ken_id
|
|
9
|
+
WHERE M.sex = '男'
|
|
9
10
|
GROUP BY
|
|
10
11
|
K.ken_id
|
|
11
12
|
, K.ken_name
|