分组数据

-- 分组数据（涉及两个新子句，GROUP BY子句和HAVING子句）

SELECT COUNT(*) AS num_prods
FROM Products
WHERE vend_id = 'DLL01';