﻿ SQL JOINS on HR: Display the first and last name and salary for those employees who earn less than the employee earn whose number is 182 - w3resource

# SQL JOINS on HR Database: Display the first and last name and salary for those employees who earn less than the employee earn whose number is 182

## SQL JOINS on HR Database: Exercise-7 with Solution

7. From the following table, write a SQL query to find those employees who earn less than the employee of ID 182. Return first name, last name and salary.

Sample table: employees

Sample Solution:

``````SELECT E.first_name, E.last_name, E.salary
FROM employees E
JOIN employees S
ON E.salary < S.salary
AND S.employee_id = 182;
``````

Sample Output:

```first_name	last_name	salary
James		Landry		2400.00
Steven		Markle		2200.00
TJ		Olson		2100.00
Ki		Gee		2400.00
Hazel		Philtanker	2200.00
```

Relational Algebra Expression:

Relational Algebra Tree:

Pictorial Presentation:

## Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

﻿