2022-10-24 14:54 西安欧亚学院 大数据开发工程师 发布于浙江
关注
SELECT
prod_name,
count(order_num)
FROM Products left JOIN OrderItems ON OrderItems.prod_id = Products .prod_id
group by prod_name
order by prod_name asc
prod_name,
count(order_num)
FROM Products left JOIN OrderItems ON OrderItems.prod_id = Products .prod_id
group by prod_name
order by prod_name asc
我已经通过这道题！
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2F1c64fd9048364a58a8ffa541720359a4
全部评论
相关推荐
notbeentak...：就抓，嗯抓，开不开匿名都要抓，一点坏事不让说，就对公司顶礼膜拜佩服的五体投地就对了 点赞 评论 收藏
分享
