题解 | 列出供应商及其可供产品的数量
列出供应商及其可供产品的数量
https://www.nowcoder.com/practice/17f22851cf204019b51a36761a3afc79
select vend_id,
count(prod_id) as prod_id
from Vendors V left join Products P using(vend_id)
group by
V.vend_id
order by
V.vend_id ASC;
阿里云成长空间 781人发布