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;

• The HAVING clause: Selecting groups of data
• Subqueries in the HAVING clause
• SELECT statement