SELECT ename (5) FROM emp (1) WHERE empno = 10 (2) GROUP BY ename (3) HAVING count(*) >= 1 (4) ORDER BY ename; (6)
FROM -> WHERE -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY