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-10 14:40
湖南文理学院 安卓 点赞 评论 收藏
分享
点赞 评论 收藏
分享


