回答編集履歴

1

修正

2018/12/05 04:31

投稿

sazi
sazi

スコア25138

test CHANGED
@@ -2,8 +2,10 @@
2
2
 
3
3
  ```SQL
4
4
 
5
- select * from A as t
5
+ select ID, sale_date, sum(discout_price) from A as t
6
6
 
7
7
  where sale_date=(select max(sale_date) from A where id=t.id)
8
8
 
9
+ group by ID, sale_date
10
+
9
11
  ```