Level 1 - Question 9: Filter Using Logical Operators (AND/OR)

Scenario

Your task is to fetch employees from either the 'Finance' department or those with a salary above 9000.

Task

Write a SQL query to return name, department, and salary from employees where the department is 'Finance' OR salary is greater than 9000.

Sample Schema: employees

emp_id	name	department	salary
101	Hasan	Finance	8800
102	Mithila	IT	9100
103	Junaid	HR	8600

Write Your SQL Answer:

Submit Answer