Level 2 - Question 6: Get Employees in 'IT' Department with Salary > 8500

Scenario

You want to list the names of employees in the IT department who earn more than 8500.

Task

Write a SQL query that joins employees and departments, and filters by department name 'IT' and salary > 8500.

Sample Schema

employees	departments
emp_id employee_name department_id salary	department_id department_name

Write Your SQL Answer:

Submit Answer