select  v.vend_id,count(p.prod_id) prod_id from Vendors v left join Products p on v.vend_id=p.vend_id group by v.vend_id order by v.vend_id