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