SELECT V.vend_id, count(prod_id) as prod_id
FROM Vendors V
LEFT JOIN Products P ON V.vend_id = P.vend_id
GROUP BY V.vend_id
ORDER BY V.vend_id