Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
WITH AVG_SALATY AS(
SELECT
EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY,
AVG(SALARY) OVER () AVG_SALATY
FROM EMPLOYEES
) SELECT * FROM AVG_SALATY WHERE SALARY > AVG_SALATY;
SELECT
EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY,
AVG(SALARY) OVER () AVG_SALATY
FROM EMPLOYEES
JOIN (
SELECT AVG(SALARY) AVG_SALATY FROM EMPLOYEES
) AVG_SALATY ON SALARY > AVG_SALATY;
SELECT
EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY,
AVG(SALARY) OVER () AVG_SALATY
FROM EMPLOYEES
CROSS JOIN (
SELECT AVG(SALARY) AVG_SALATY FROM EMPLOYEES
) AVG_SALATY
WHERE SALARY > AVG_SALATY;