xiaojiahuo68

分类

题解(5)

/ 注册

全部文章（共2篇）

题解 | #返回产品名称和每一项产品的总订单数#

SELECT a.prod_name,count(b.order_num) orders FROM Products a left join OrderItems b on a.prod_id=b.prod_id group by a.prod_name union SELECT a.prod_na...

Mysql

2022-06-18

0 405

题解 | #返回产品名称和与之相关的订单号#

SELECT a.prod_name,b.order_num FROM Products a left join OrderItems b on a.prod_id=b.prod_id union SELECT a.prod_name,b.order_num FROM Products a left...

Mysql

2022-06-17

0 270