SQL SORTING and FILTERING on HR Database: Display the first and last_name, department number and salary for those employees who earn more than 8000

SQL SORTING and FILTERING on HR Database: Exercise-2 with Solution

2. From the following table, write a SQL query to find those employees whose salary is higher than 8000. Return first name, last name and department number and salary.

Sample table: employees

Sample Solution:

SELECT first_name,last_name, department_id, salary
 FROM employees
  WHERE salary > 8000;

Sample Output:

 first_name | last_name  | department_id |  salary
------------+------------+---------------+----------
 Steven     | King       |            90 | 24000.00
 Neena      | Kochhar    |            90 | 17000.00
 Lex        | De Haan    |            90 | 17000.00
 Alexander  | Hunold     |            60 |  9000.00
 Nancy      | Greenberg  |           100 | 12000.00
 Daniel     | Faviet     |           100 |  9000.00
 John       | Chen       |           100 |  8200.00
 Den        | Raphaely   |            30 | 11000.00
 Adam       | Fripp      |            50 |  8200.00
 John       | Russell    |            80 | 14000.00
 Karen      | Partners   |            80 | 13500.00
 Alberto    | Errazuriz  |            80 | 12000.00
 Gerald     | Cambrault  |            80 | 11000.00
 Eleni      | Zlotkey    |            80 | 10500.00
 Peter      | Tucker     |            80 | 10000.00
 David      | Bernstein  |            80 |  9500.00
 Peter      | Hall       |            80 |  9000.00
 Janette    | King       |            80 | 10000.00
 Patrick    | Sully      |            80 |  9500.00
 Allan      | McEwen     |            80 |  9000.00
 Clara      | Vishney    |            80 | 10500.00
 Danielle   | Greene     |            80 |  9500.00
 Lisa       | Ozer       |            80 | 11500.00
 Harrison   | Bloom      |            80 | 10000.00
 Tayler     | Fox        |            80 |  9600.00
 Ellen      | Abel       |            80 | 11000.00
 Alyssa     | Hutton     |            80 |  8800.00
 Jonathon   | Taylor     |            80 |  8600.00
 Jack       | Livingston |            80 |  8400.00
 Michael    | Hartstein  |            20 | 13000.00
 Hermann    | Baer       |            70 | 10000.00
 Shelley    | Higgins    |           110 | 12000.00
 William    | Gietz      |           110 |  8300.00
(33 rows)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: From the following table, write a SQL query to find those employees whose salary is less than 6000. Return full name (first and last name), and salary.
Next: From the following table, write a SQL query to find those employees whose last name is "McEwen". Return first name, last name and department ID.