分组数据 -- 分组数据(涉及两个新子句,GROUP BY子句和HAVING子句) SELECT COUNT(*) AS num_prodsFROM ProductsWHERE vend_id = 'DLL01';