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