above average salary in sql

1SELECT FIRST_NAME FROM EMPLOYEES
2WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

1SELECT FIRST_NAME, LAST_NAME
2FROM EMPLOYEES
3WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);

1SELECT FIRST_NAME FROM EMPLOYEES
2WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);