回答編集履歴
1
調整
test
CHANGED
|
@@ -42,9 +42,9 @@
|
|
|
42
42
|
|
|
43
43
|
select dt
|
|
44
44
|
|
|
45
|
-
,sum(val*case when label='A' then 1 else 0 end) as A
|
|
45
|
+
,sum(val*(case when label='A' then 1 else 0 end)) as A
|
|
46
46
|
|
|
47
|
-
,sum(val*case when label='B' then 1 else 0 end) as B
|
|
47
|
+
,sum(val*(case when label='B' then 1 else 0 end)) as B
|
|
48
48
|
|
|
49
49
|
from tbl
|
|
50
50
|
|