题解 | #列出供应商及其可供产品的数量#

SELECT V.vend_id,COUNT(P.prod_id)
FROM Vendors AS V LEFT JOIN Products AS P
ON V.vend_id=P.vend_id
GROUP BY V.vend_id
ORDER BY V.vend_id;