L1 Q7
Beginner Level
Practice Question
Level 1 - Question 7: Sort Employees by Salary (Descending)
Scenario
The HR department wants to view employees in order of their salary - highest paid first.
Task
Write a SQL query to return name and salary from the employees table, sorted by salary in descending order.
Sample Schema: employees
| emp_id | name | department | salary |
|---|---|---|---|
| 301 | Nazmul | IT | 8900 |
| 302 | Shaheda | Finance | 9200 |
| 303 | Raihan | HR | 7500 |