回答編集履歴
1
追記
answer
CHANGED
|
@@ -36,4 +36,30 @@
|
|
|
36
36
|
) as dummy
|
|
37
37
|
group by month;
|
|
38
38
|
```
|
|
39
|
-
なんか効率的な方法がありそうな気がしますが・・・
|
|
39
|
+
なんか効率的な方法がありそうな気がしますが・・・
|
|
40
|
+
|
|
41
|
+
- 別案
|
|
42
|
+
```SQL
|
|
43
|
+
select month
|
|
44
|
+
,sum(c1) as c1
|
|
45
|
+
,sum(c2) as c2
|
|
46
|
+
,sum(c3) as c3
|
|
47
|
+
,sum(c4) as c4
|
|
48
|
+
from
|
|
49
|
+
(select DATE_FORMAT(interview,'%Y%m') as month,count(*) as c1,0 as c2,0 as c3,0 as c4 from tbl group by month
|
|
50
|
+
union select DATE_FORMAT(decision,'%Y%m') as month,0,count(*),0,0 from tbl group by month
|
|
51
|
+
union select DATE_FORMAT(accept,'%Y%m') as month,0,0,count(*),0 from tbl group by month
|
|
52
|
+
union select DATE_FORMAT(ng,'%Y%m') as month,0,0,0,count(*) from tbl group by month
|
|
53
|
+
union select '201603',0,0,0,0
|
|
54
|
+
union select '201604',0,0,0,0
|
|
55
|
+
union select '201605',0,0,0,0
|
|
56
|
+
union select '201606',0,0,0,0
|
|
57
|
+
union select '201607',0,0,0,0
|
|
58
|
+
union select '201608',0,0,0,0
|
|
59
|
+
union select '201609',0,0,0,0
|
|
60
|
+
union select '201610',0,0,0,0
|
|
61
|
+
union select '201611',0,0,0,0
|
|
62
|
+
union select '201612',0,0,0,0
|
|
63
|
+
) as dummy
|
|
64
|
+
group by month;
|
|
65
|
+
```
|