题解 | #列出供应商及其可供产品的数量#
列出供应商及其可供产品的数量
https://www.nowcoder.com/practice/17f22851cf204019b51a36761a3afc79
select
Vendors.vend_id,
count(prod_id) as prod_id
from
Vendors left join Products
on Vendors.vend_id = Products.vend_id
group by
vend_id
order by
vend_id
小天才公司福利 696人发布
