回答編集履歴
1
変更
test
CHANGED
@@ -6,11 +6,11 @@
|
|
6
6
|
|
7
7
|
```sql
|
8
8
|
|
9
|
-
select
|
9
|
+
select date_format(t9.create_datetime, '%m-%d') MMDD,
|
10
10
|
|
11
|
-
min(c01), max(c01), avg(
|
11
|
+
min(c01), max(c01), avg(time_to_sec(c01)) av01,
|
12
12
|
|
13
|
-
min(c12), max(c12), avg(
|
13
|
+
min(c12), max(c12), avg(time_to_sec(c12)) av02
|
14
14
|
|
15
15
|
from
|
16
16
|
|