select V.vend_id,count(prod_id) as prod_id from Vendors V
left join Products P on P.vend_id = V.vend_id
group by vend_id
order by vend_id;
select V.vend_id,count(prod_id) as prod_id from Vendors V
left join Products P on P.vend_id = V.vend_id
group by vend_id
order by vend_id;