```json { "queries": [ { "query": "SELECT \"Survived\", COUNT(*) AS passengers FROM titanic GROUP BY \"Survived\" ORDER BY \"Survived\"", "description": "Number of passengers who survived versus those who did not." }, { "query": "SELECT \"Pclass\", AVG(\"Survived\") AS survival_rate FROM titanic WHERE \"Survived\" IS NOT NULL GROUP BY \"Pclass\" ORDER BY \"Pclass\"", "description": "Survival rate by passenger class, showing which class had better odds." }, { "query": "SELECT \"Sex\", COUNT(*) AS total, SUM(\"Survived\") AS survived FROM titanic WHERE \"Survived\" IS NOT NULL GROUP BY \"Sex\"", "description": "Total passengers and survivors broken down by gender." }, { "query": "SELECT \"Embarked\", COUNT(*) AS passengers, AVG(\"Fare\") AS avg_fare FROM titanic WHERE \"Embarked\" IS NOT NULL GROUP BY \"Embarked\" ORDER BY avg_fare DESC", "description": "Average ticket fare and passenger count by port of embarkation." }, { "query": "SELECT \"Name\", \"Age\", \"Survived\", \"Pclass\" FROM titanic WHERE \"Age\" IS NOT NULL ORDER BY \"Age\" DESC LIMIT 10", "description": "Ten oldest passengers on the Titanic with their survival status and class." }, { "query": "SELECT \"Pclass\", \"Sex\", AVG(\"Age\") AS avg_age FROM titanic WHERE \"Age\" IS NOT NULL GROUP BY \"Pclass\", \"Sex\" ORDER BY \"Pclass\", \"Sex\"", "description": "Average age of passengers by class and gender." }, { "query": "SELECT \"SibSp\" + \"Parch\" AS family_size, AVG(\"Survived\") AS survival_rate FROM titanic WHERE \"Survived\" IS NOT NULL GROUP BY family_size ORDER BY family_size", "description": "Survival rate by family size aboard the ship." }, { "query": "SELECT \"Pclass\", MIN(\"Fare\") AS min_fare, MAX(\"Fare\") AS max_fare, AVG(\"Fare\") AS avg_fare FROM titanic WHERE \"Fare\" IS NOT NULL GROUP BY \"Pclass\" ORDER BY \"Pclass\"", "description": "Fare statistics showing minimum, maximum, and average by passenger class." }, { "query": "SELECT \"Name\", \"Fare\", \"Pclass\" FROM titanic WHERE \"Fare\" IS NOT NULL ORDER BY \"Fare\" DESC LIMIT 10", "description": "Ten passengers who paid the highest fares with their class." }, { "query": "SELECT \"Age\", \"Sex\", \"Survived\", \"Pclass\", \"Fare\" FROM titanic WHERE \"Age\" < 18 AND \"Survived\" IS NOT NULL ORDER BY \"Age\" LIMIT 15", "description": "Children under 18 on the Titanic with their survival outcomes and ticket details." } ] } ```