L1 Q6
Beginner Level
Practice Question
Level 1 - Question 6: Filter Employees with Salary > 9000
Scenario
Your HR manager wants to identify employees earning more than 9000 for a bonus review.
Task
Write a SQL query to return name and salary from the employees table where salary is greater than 9000.
Sample Schema: employees
| emp_id | name | department | salary |
|---|---|---|---|
| 101 | Rezaul Islam | IT | 9800 |
| 102 | Sadia Akter | Sales | 8600 |
| 103 | Hasan Chowdhury | IT | 10400 |