Using the HAVING Clause
Just as a WHERE clause reduces the number of rows returned by a SELECT clause, the HAVING clause can be used to reduce the number of rows returned by a GROUP BY clause. Like the WHERE clause, a HAVING clause has a search condition. However, in a HAVING clause, the search condition typically corresponds to an aggregate function used in the SELECT clause.
Controlling your Query with GROUP BY and HAVING
Issue the following query to list the departments that have an average budget of over $60,000 and order the result set by department.
SELECT Department, AVG(budget) FROM department
GROUP BY Department
HAVING AVG(budget) >60000
ORDER BY Department
- The result set should look like this: