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". Free accounts get 10 free challenge solves, and this can be one of them.
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
Concepts
SELECT WHERE IN
Practise the topic: SQL practice questions
Read the concept: Learn SQL for beginners
Related questions
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