题解 | 列出供应商及其可供产品的数量
列出供应商及其可供产品的数量
https://www.nowcoder.com/practice/17f22851cf204019b51a36761a3afc79
select V.vend_id,count(P.prod_id) prod_id from Vendors V left join Products P using (vend_id) group by V.vend_id order by V.vend_id
列出供应商及其可供产品的数量
https://www.nowcoder.com/practice/17f22851cf204019b51a36761a3afc79
select V.vend_id,count(P.prod_id) prod_id from Vendors V left join Products P using (vend_id) group by V.vend_id order by V.vend_id
相关推荐