質問編集履歴
1
コードにマークダウンを利用した
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -12,6 +12,8 @@
|
|
|
12
12
|
|
|
13
13
|
|
|
14
14
|
|
|
15
|
+
```ここに言語を入力
|
|
16
|
+
|
|
15
17
|
SELECT DATE_FORMAT(uit.UserInsertDate, '%Y%m')month,uit.RegistrationCode, count(uit2.RegistrationCode) count
|
|
16
18
|
|
|
17
19
|
FROM user_info_table uit LEFT JOIN user_info_table uit2
|
|
@@ -23,6 +25,8 @@
|
|
|
23
25
|
where DATE_FORMAT(uit.UserInsertDate, '%Y') = '2010'
|
|
24
26
|
|
|
25
27
|
GROUP BY DATE_FORMAT(uit.UserInsertDate, '%Y%m'),uit.RegistrationCode;
|
|
28
|
+
|
|
29
|
+
```
|
|
26
30
|
|
|
27
31
|
|
|
28
32
|
|