SQL Quest › SQL Interview Questions › Conditional Logic
Family Size Survival Buckets
A sociology paper is measuring how family size affected survival. Compute family_size = sibsp + parch + 1 (siblings + parents/children + the passenger themselves). Bucket into 'Solo' (exactly 1), 'Small family' (2–4), 'Large family' (5 or more). For each bucket, show family_category, passenger_count, survival_rate (as a percent, rounded to 1 decimal), and avg_fare (rounded to 2 decimals). Sort by survival_rate descending. This pattern — compute → categorize → aggregate — is bread-and-butter analytics.
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: Solo | 537 | 30.3 | 21.24
Hint
Concepts
SELECT CASE GROUP BY Aggregation Calculated Column BETWEEN CASE + GROUP BY
Practise the topic: SQL practice questions · CASE WHEN practice · GROUP BY exercises
In these company practice sets
A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.
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