回答編集履歴
1
エラーになる「,」を削除しました。
answer
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
```SQL
|
|
2
2
|
SELECT
|
|
3
3
|
CASE WHEN c = 'WWW' or c = 'ZZZ' THEN a ELSE null end as a,
|
|
4
|
-
CASE WHEN c = 'WWW' or c = 'ZZZ' THEN b ELSE null end as b
|
|
4
|
+
CASE WHEN c = 'WWW' or c = 'ZZZ' THEN b ELSE null end as b
|
|
5
5
|
FROM
|
|
6
6
|
DatabaseName.TableName;
|
|
7
7
|
```
|