Sub Query - 1 --- Sub Queries

SESSION NAME: Sub Queries.

QUESTION NAME: Sub Query - 1.

TABLE DESCRIPTION:

Write a query to display the name ( first name and last
name ) for those employees who gets more salary than
the employee whose ID is 163

Table name = sub_employees
Use Sub Queries

CODE:

select first_name, last_name from sub_employees where salary >  (select salary from sub_employees where employee_id = 163);