白恩学JAVA

分类

题解(2)

/ 注册

全部文章（共1篇）

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

select a1.prod_name,count(a2.order_num) from Products as a1 left join OrderItems as a2 on a1.prod_id = a2.prod_id group by a1.prod_name order by a1.p...

Mysql

2022-04-27

0 592