SELECT vd.vend_id, 
COALESCE(COUNT(prod_id),0) AS prod_id
FROM Vendors AS vd
LEFT JOIN Products AS p
ON vd.vend_id = p.vend_id
GROUP BY vend_id
ORDER BY vend_id