Aggregate functions. can be used in both HAVING and WHERE clauses.

Aggregate functions. can be used in both HAVING and WHERE clauses.

True

False

SUPPLIER $($ID$,$ Name, ContactPersonName, Address, City, State, Zip, Phone, Email$)$

Suppose you want to count the number of products supplied by each supplier. You have already written part of the code:

SELECT$$ Supplier.Name,$\_\_\_\_\_\_(3)\_\_\_\_\_\_$

FROM $\_\_\_\_\_\_\_\_\_\_(1)\_\_\_\_\_\_\_\_\_$

$\_\_\_\_\_\_\_\_\_\_\_(2)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ ;

What would you write to fill in the gap $(2)?$

GROUP BY Supplier.Name

ORDER BY Supplier.Name

GROUP BY Supplier

GROUP BY Product.Name