SQL Quest › SQL Interview Questions › Querying Basics
The IN Operator
Find employees in the Engineering, Marketing, or Sales departments. Show name, department, position, and salary. Sort by department, then salary descending. IN is cleaner than writing multiple OR conditions.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".
Schema
employees
| emp_id | name | department | position | salary | hire_date | manager_id | performance_rating |
|---|---|---|---|---|---|---|---|
| 1 | Alice Johnson | Engineering | Senior Developer | 95000 | 2019-03-15 | 5 | 4.5 |
| 2 | Bob Smith | Engineering | Developer | 75000 | 2020-06-01 | 1 | 3.8 |
| 3 | Carol Williams | Marketing | Marketing Manager | 85000 | 2018-09-20 | NULL | 4.2 |
Expected output: Employees from 3 specific departments
Hint
WHERE department IN ('Engineering', 'Marketing', 'Sales') is equivalent to department = 'Engineering' OR department = 'Marketing' OR department = 'Sales'.
Concepts
SELECT WHERE IN
Practise the topic: SQL practice questions
Related questions
Your First QueryEasy · FreePick Your ColumnsEasy · FreeFilter with WHEREEasy · FreeComparison OperatorsEasy · FreeMultiple Conditions (AND / OR)Easy · FreeSorting and LimitingEasy · Free
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test