EQL provides two filtering options: WHERE and HAVING. The HAVING clause is used to filter output records.
Its syntax is as follows:
HAVING <Boolean expression>
In the following example, the results include only sales representatives who generated at least $10,000:
Return Reps AS SELECT SUM(Amount) AS SalesTotal GROUP BY SalesRep HAVING SalesTotal > 10000