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