SQL Interview Question: - Find all employees whose salary is greater than the average salary of all employees

Questiion:

Find all employees whose salary is greater than the average salary of all employees.

Required result:

emp_id, 

first_name, 

last_name, 

salary

Dataset

 select emp_id, first_name, last_name, salary from employees

 where salary > (

    select avg(salary)

                         from employees);

See Result Below:-

 

Thanks