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

select
    a.vend_id,
    coalesce(count(prod_id),0) as prod_id
from
    Vendors a
left join
    Products b on a.vend_id = b.vend_id
group by 
    1
order by 
    1