回答編集履歴
1
コーディングミスを訂正
test
CHANGED
@@ -10,9 +10,9 @@
|
|
10
10
|
|
11
11
|
account
|
12
12
|
|
13
|
-
, SUM(CASE WHEN color THEN face ELSE 0 END AS color_faces -- カラー面数
|
13
|
+
, SUM(CASE WHEN color THEN face ELSE 0 END) AS color_faces -- カラー面数
|
14
14
|
|
15
|
-
, SUM(CASE WHEN NOT color THEN face ELSE 0 END AS mono_faces --
|
15
|
+
, SUM(CASE WHEN NOT color THEN face ELSE 0 END) AS mono_faces -- モノクロ面数
|
16
16
|
|
17
17
|
, SUM(face) AS total_faces
|
18
18
|
|