select
Vendors.vend_id,
COUNT(Products.prod_id) AS prod_id
from
Products
RIGHT JOIN Vendors ON Vendors.vend_id = Products.vend_id
GROUP BY
Vendors.vend_id
ORDER BY Vendors.vend_id ASC
Vendors.vend_id,
COUNT(Products.prod_id) AS prod_id
from
Products
RIGHT JOIN Vendors ON Vendors.vend_id = Products.vend_id
GROUP BY
Vendors.vend_id
ORDER BY Vendors.vend_id ASC
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2F17f22851cf204019b51a36761a3afc79
全部评论
相关推荐
点赞 评论 收藏
分享
10-30 11:21
北京邮电大学 Java 点赞 评论 收藏
分享
11-30 21:55
哈尔滨华德学院 Java 点赞 评论 收藏
分享
阿里云工作强度 690人发布
