SQL Quest › SQL Interview Questions › Querying Basics
Working-Age Passengers (BETWEEN)
An insurance analyst is profiling passengers who would have been in the workforce age range at the time of the voyage. Use the BETWEEN operator to find passengers aged 18 to 65 inclusive.
Show name, sex, age. Order by age ascending, then name ascending.
age BETWEEN 18 AND 65 is equivalent to age >= 18 AND age <= 65 but reads more clearly when you mean an inclusive range — and it's the form interviewers expect when the prompt says "between".
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
passengers
| passenger_id | survived | pclass | name | sex | age | sibsp | parch | fare | embarked |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 3 | Braund, Mr. Owen Harris | male | 22 | 1 | 0 | 7.25 | S |
| 2 | 1 | 1 | Cumings, Mrs. John Bradley | female | 38 | 1 | 0 | 71.28 | C |
| 3 | 1 | 3 | Heikkinen, Miss. Laina | female | 26 | 0 | 0 | 7.93 | S |
Expected output: Only the 22-year-old and 45-year-old appear
Hint
Concepts
SELECT WHERE BETWEEN ORDER BY
Practise the topic: SQL practice questions
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