select V.vend_id,count(P.prod_id) prod_id from Vendors V left join Products P using (vend_id) group by V.vend_id order by V.vend_id
select V.vend_id,count(P.prod_id) prod_id from Vendors V left join Products P using (vend_id) group by V.vend_id order by V.vend_id