Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Restrict the rows in groups by using the HAVING clause.
In Interactive SQL, execute the following query to list all sales representatives with more than 55 orders:
SELECT SalesRepresentative, COUNT( * ) AS orders
FROM SalesOrders KEY JOIN Employees
GROUP BY SalesRepresentative
HAVING count( * ) > 55
ORDER BY orders DESC;