{
    "queries": [
        {
            "query": "SELECT Primary_Platform, COUNT(*) AS students FROM Social_media_impact_on_life GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Number of students using each primary social media platform, most popular first."
        },
        {
            "query": "SELECT Primary_Platform, AVG(Daily_Usage_Hours) AS avg_hours FROM Social_media_impact_on_life WHERE Daily_Usage_Hours IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average daily social media hours by platform."
        },
        {
            "query": "SELECT Academic_Level, AVG(Academic_Performance_GPA) AS avg_gpa, AVG(Daily_Usage_Hours) AS avg_hours FROM Social_media_impact_on_life GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average GPA and daily usage for each academic level."
        },
        {
            "query": "SELECT Late_Night_Usage, AVG(Sleep_Duration_Hours) AS avg_sleep, AVG(Sleep_Quality_Score) AS avg_quality FROM Social_media_impact_on_life GROUP BY 1",
            "description": "Compares sleep duration and quality for late-night and non-late-night users."
        },
        {
            "query": "SELECT Overall_Impact, COUNT(*) AS students, AVG(Mental_Health_Index) AS avg_mental_health FROM Social_media_impact_on_life GROUP BY 1 ORDER BY 2 DESC",
            "description": "Student counts and average mental health index by overall impact rating."
        },
        {
            "query": "SELECT Social_Comparison_Frequency, AVG(Perceived_Stress_Score) AS avg_stress FROM Social_media_impact_on_life WHERE Perceived_Stress_Score IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average perceived stress by how often students compare themselves to others."
        },
        {
            "query": "SELECT Student_ID, Age, Primary_Platform, Daily_Usage_Hours, Sleep_Duration_Hours FROM Social_media_impact_on_life WHERE Daily_Usage_Hours IS NOT NULL ORDER BY Daily_Usage_Hours DESC LIMIT 10",
            "description": "The ten students with the highest daily social media usage."
        },
        {
            "query": "SELECT Gender, Device_Type, COUNT(*) AS students FROM Social_media_impact_on_life GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 10",
            "description": "Most common gender and device type combinations."
        },
        {
            "query": "SELECT MIN(Academic_Performance_GPA) AS min_gpa, AVG(Academic_Performance_GPA) AS avg_gpa, MAX(Academic_Performance_GPA) AS max_gpa FROM Social_media_impact_on_life WHERE Academic_Performance_GPA IS NOT NULL",
            "description": "Lowest, average and highest GPA across all students."
        }
    ]
}