回答編集履歴
1
調整
answer
CHANGED
|
@@ -20,8 +20,8 @@
|
|
|
20
20
|
|
|
21
21
|
```SQL
|
|
22
22
|
select dt
|
|
23
|
-
,sum(val*case when label='A' then 1 else 0 end) as A
|
|
23
|
+
,sum(val*(case when label='A' then 1 else 0 end)) as A
|
|
24
|
-
,sum(val*case when label='B' then 1 else 0 end) as B
|
|
24
|
+
,sum(val*(case when label='B' then 1 else 0 end)) as B
|
|
25
25
|
from tbl
|
|
26
26
|
group by dt
|
|
27
27
|
```
|