回答編集履歴
1
訂正
answer
CHANGED
@@ -1,9 +1,9 @@
|
|
1
1
|
こんな漢字で、
|
2
2
|
```SQL
|
3
3
|
SELECT
|
4
|
-
CASE WHEN "区分A" = 0 AND "区分B" = 0 THEN "売上高 "ELSE 0 END AS "売上高種別1"
|
4
|
+
CASE WHEN "区分A" = '0' AND "区分B" = '0' THEN "売上高 "ELSE 0 END AS "売上高種別1"
|
5
|
-
,CASE WHEN "区分A" = 0 AND "区分B" = 1 THEN "売上高" ELSE 0 END AS "売上高種別2"
|
5
|
+
,CASE WHEN "区分A" = '0' AND "区分B" = '1' THEN "売上高" ELSE 0 END AS "売上高種別2"
|
6
|
-
,CASE WHEN "区分A" = 1 AND "区分B" = 0 THEN "売上高" ELSE 0 END AS "売上高種別3"
|
6
|
+
,CASE WHEN "区分A" = '1' AND "区分B" = '0' THEN "売上高" ELSE 0 END AS "売上高種別3"
|
7
|
-
,CASE WHEN "区分A" = 1 AND "区分B" = 1 THEN "売上高" ELSE 0 END AS "売上高種別4"
|
7
|
+
,CASE WHEN "区分A" = '1' AND "区分B" = '1' THEN "売上高" ELSE 0 END AS "売上高種別4"
|
8
8
|
(以下略)
|
9
9
|
```
|