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