NiimiSora

分类

题解(7)

/ 注册

全部文章（共2篇）

题解 | SQL95 使用left join的写法

一种使用left join的写法 select prod_name, sum(quantity) quant_sold from Products left join OrderItems using(prod_id) group by prod_name;

Mysql

2022-10-19

4 624

题解 | #返回每个顾客不同订单的总金额#

left join解法 select cust_id, sum(item_price * quantity) total_ordered from Orders left join OrderItems using(order_num) group by cust_id orde...

Mysql

2022-10-17

0 246