w3resource
SQL exercises

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. Write a query in SQL to display the first and last_name, department number and salary for those employees who earn more than 8000.

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)

Practice Online


HR database model

Query Visualization:

Duration:

Query visualization of Display the first and last_name, department number and salary for those employees who earn more than 8000 - Duration

Rows:

Query visualization of Display the first and last_name, department number and salary for those employees who earn more than 8000 - Rows

Cost:

Query visualization of Display the first and last_name, department number and salary for those employees who earn more than 8000 - Cost

Contribute your code and comments through Disqus.

Previous: Write a query in SQL to display the full name (first and last name), and salary for those employees who earn below 6000.
Next: Write a query in SQL to display the first and last name, and department number for all employees whose last name is "McEwen".

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming