题解 | #列出供应商及其可供产品的数量#

select t1.vend_id,count(prod_id)
from Vendors t1
left join Products t2
on t1.vend_id=t2.vend_id
group by t1.vend_id
order by t1.vend_id asc