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