回答編集履歴
2
コード修正
test
CHANGED
|
@@ -18,11 +18,11 @@
|
|
|
18
18
|
|
|
19
19
|
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.interview,'%Y%m') THEN 1 ELSE 0 END) AS interview_cnt
|
|
20
20
|
|
|
21
|
-
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.decision,'%Y%m') THEN 1 ELSE 0 END) decision_cnt
|
|
21
|
+
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.decision,'%Y%m') THEN 1 ELSE 0 END) AS decision_cnt
|
|
22
22
|
|
|
23
|
-
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.accept,'%Y%m') THEN 1 ELSE 0 END) accept_cnt
|
|
23
|
+
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.accept,'%Y%m') THEN 1 ELSE 0 END) AS accept_cnt
|
|
24
24
|
|
|
25
|
-
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.ng,'%Y%m') THEN 1 ELSE 0 END) ng_cnt
|
|
25
|
+
, SUM(CASE WHEN cal.month = DATE_FORMAT(t.ng,'%Y%m') THEN 1 ELSE 0 END) AS ng_cnt
|
|
26
26
|
|
|
27
27
|
FROM
|
|
28
28
|
|
|
@@ -67,3 +67,5 @@
|
|
|
67
67
|
|
|
68
68
|
|
|
69
69
|
8月度が漏れてました・・・
|
|
70
|
+
|
|
71
|
+
|
1
コードミス修正
test
CHANGED
|
@@ -38,6 +38,8 @@
|
|
|
38
38
|
|
|
39
39
|
UNION ALL SELECT '201607'
|
|
40
40
|
|
|
41
|
+
UNION ALL SELECT '201608'
|
|
42
|
+
|
|
41
43
|
UNION ALL SELECT '201609'
|
|
42
44
|
|
|
43
45
|
UNION ALL SELECT '201610'
|
|
@@ -61,3 +63,7 @@
|
|
|
61
63
|
cal.month
|
|
62
64
|
|
|
63
65
|
```
|
|
66
|
+
|
|
67
|
+
|
|
68
|
+
|
|
69
|
+
8月度が漏れてました・・・
|