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;