两表sql查询语句

Question

如图两个表
1，查询出订单id,订单名称和订单金额，根据金额排序
2.根据订单id计算金额的总数，返回订单id和订单金额
3。将订单id为999的金额修改为1000
4，删除id为999的信息
怎么回事！！！

Answer 1

1，select b.订单id,b.订单名称,a.订单金额
from order_line a left join order b on a.订单明细id=b.订单id
order by a.订单金额
2, select b.订单id,sum(a.订单金额) 金额
from order_line a left join order b on a.订单明细id=b.订单id
group by b.订单id,b.订单名称
3, update order_line
set 订单金额=1000
where a.订单明细id=999
4, delete order_line
where 订单明细id=999

delete order
where 订单id=999

Answer 2

1、seelct b.ID,a.name,b.money from order a ,order_line b
where a.ID = b.ID order by b.money

2、select b.ID,a.name,sum(b.money) from order a ,order_line b
where a.ID = b.ID group by b.ID,a.name order by sum(b.money)

3、update order_line set money = 1000 where id = 999
所有明细都改为1000了

4、delete from order where id = 999
delete from order_line where id = 999