回答編集履歴
1
推敲
test
CHANGED
|
@@ -36,7 +36,7 @@
|
|
|
36
36
|
|
|
37
37
|
where lectures.finish_time in (2021/05/01 and 2021/06/30)
|
|
38
38
|
|
|
39
|
-
group by students.name, date_format(lectures.finish_time, '%Y%
|
|
39
|
+
group by students.name, date_format(lectures.finish_time, '%Y%m')
|
|
40
40
|
|
|
41
41
|
) mnth
|
|
42
42
|
|