Sub Query - 4 --- Sub Queries

SESSION NAME: Sub Queries.

QUESTION NAME: Sub Query - 4.

TABLE DESCRIPTION:

Write a query to display the employee id, employee name
(first name and last name ) for all employees who earn
more than the average salary

Table name = sub_employees
Use Sub Queries

CODE:

SELECT employee_id, first_name,last_name   FROM sub_employees   WHERE salary >   ( SELECT AVG(salary)   FROM sub_employees  );