回答編集履歴
1
変更
test
CHANGED
|
@@ -2,9 +2,11 @@
|
|
|
2
2
|
|
|
3
3
|
```sql
|
|
4
4
|
|
|
5
|
-
select user_id, player_id, main_all from user_score join
|
|
5
|
+
select user_id, player_id, sum(main_all) main_all from user_score join
|
|
6
6
|
|
|
7
|
-
player_id from player group by 1) t1
|
|
7
|
+
(select user_id, max(player_id) player_id from player group by 1) t1
|
|
8
|
+
|
|
9
|
+
using(player_id) group by 1,2;
|
|
8
10
|
|
|
9
11
|
|
|
10
12
|
|