回答編集履歴
2
推敲
test
CHANGED
|
@@ -22,7 +22,7 @@
|
|
|
22
22
|
|
|
23
23
|
, sum(time) as group_time
|
|
24
24
|
|
|
25
|
-
from sample
|
|
25
|
+
from sample1
|
|
26
26
|
|
|
27
27
|
group by
|
|
28
28
|
|
1
推敲
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
select sample1.*
|
|
8
8
|
|
|
9
|
-
, time +
|
|
9
|
+
, time + group_time as result
|
|
10
10
|
|
|
11
11
|
from sample1 left join (
|
|
12
12
|
|
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
|
|
21
21
|
end as class
|
|
22
22
|
|
|
23
|
-
, sum(time) as
|
|
23
|
+
, sum(time) as group_time
|
|
24
24
|
|
|
25
25
|
from sample
|
|
26
26
|
|