What can be used in a SELECT statement to obtain search criteria for the SELECT statement?
HAVING clause
ORDER BY clause
Subquery
GROUP BY clause