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;