L1 Q10
Beginner Level
Practice Question
Level 1 - Question 10: Filter Employees from Specific Departments Using IN
Scenario
Your manager wants a list of employees who work in either the 'IT' or 'Sales' departments.
Task
Write a SQL query to return name and department of employees where the department is either 'IT' or 'Sales'.
Sample Schema: employees
| emp_id | name | department | salary |
|---|---|---|---|
| 201 | Alam | IT | 8900 |
| 202 | Rina | Sales | 7700 |
| 203 | Jasim | HR | 8200 |