Level 2 - Question 8: List Employees in Sales or IT Departments

Scenario

You want to retrieve all employees who belong to departments named 'Sales' or 'IT'.

Task

Use a subquery with IN to list employee_name from employees who work in those departments.

Sample Schema

employees	departments
emp_id employee_name department_id	department_id department_name

Write Your SQL Answer:

Submit Answer