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, salary FROM employees
2WHERE salary <= (SELECT AVG(salary) FROM employees);