回答編集履歴
1
追加
answer
CHANGED
|
@@ -3,4 +3,14 @@
|
|
|
3
3
|
SELECT SUM(case when area=1 then ticket else 0 end) AS total,
|
|
4
4
|
SUM(case when area=0 then suji else 0 end) AS ex_total
|
|
5
5
|
FROM hoge;
|
|
6
|
+
```
|
|
7
|
+
|
|
8
|
+
whereを使ったものも作成
|
|
9
|
+
```sql
|
|
10
|
+
SELECT SUM(ticket), SUM(suji) FROM
|
|
11
|
+
(
|
|
12
|
+
SELECT ticket, 0 as suji FROM hoge WHERE area=1
|
|
13
|
+
UNION ALL
|
|
14
|
+
SELECT 0, suji FROM hoge WHERE area=0
|
|
15
|
+
) t1;
|
|
6
16
|
```
|