You have already seen how to restrict rows in a result set using the WHERE clause. You restrict the rows in groups using the HAVING clause.
In Interactive SQL, execute the following query:
SELECT SalesRepresentative, count( * ) AS orders FROM SalesOrders KEY JOIN Employees GROUP BY SalesRepresentative HAVING count( * ) > 55 ORDER BY orders DESC;
For more information about the HAVING clause, see The HAVING clause: selecting groups of data.