SQL Quest › SQL Interview Questions › Aggregation & Grouping

Full Survival Dashboard by Class

MediumFreeQuerying BasicsAggregation & Grouping

Build a complete class-level survival report. Show exactly these 6 columns, in this order: pclass, total (passenger count), survivors, survival_rate (%, 1 decimal), avg_fare (2 decimals), avg_age (1 decimal — AVG skips NULLs automatically). Order by pclass.

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	fare	embarked
1	0	3	Braund, Mr. Owen Harris	male	22	1	7.25	S
2	1	1	Cumings, Mrs. John Bradley	female	38	1	71.28	C
3	1	3	Heikkinen, Miss. Laina	female	26	0	7.93	S

Expected output: 3 rows with full stats per class

Hint

Five aggregates in one GROUP BY: COUNT(*), SUM(survived), ROUND(100.0*SUM/COUNT,1), ROUND(AVG(fare),2), ROUND(AVG(age),1). AVG ignores NULLs automatically

Concepts

SELECT GROUP BY Aggregation ORDER BY

Practise the topic: SQL practice questions · GROUP BY exercises

In these company practice sets

Snowflake

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Full Survival Dashboard by Class

Schema

Hint

Concepts

In these company practice sets

Related questions