
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

Query Visualization:
Duration:

Rows:

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