{
    "queries": [
        {
            "query": "SELECT sleep_debt_category, COUNT(*) AS users FROM bedtime_screentime_sleep_debt GROUP BY 1 ORDER BY 2 DESC",
            "description": "Number of users in each sleep debt category, largest first."
        },
        {
            "query": "SELECT primary_bedtime_app, AVG(sleep_latency_min) AS avg_latency_min, COUNT(*) AS users FROM bedtime_screentime_sleep_debt WHERE sleep_latency_min IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average time to fall asleep by the app used most at bedtime."
        },
        {
            "query": "SELECT chronotype, AVG(total_sleep_hours) AS avg_sleep_hours, AVG(next_day_fatigue_score) AS avg_fatigue FROM bedtime_screentime_sleep_debt GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average sleep hours and next-day fatigue for each chronotype."
        },
        {
            "query": "SELECT occupation_type, AVG(bedtime_phone_minutes) AS avg_phone_min FROM bedtime_screentime_sleep_debt WHERE bedtime_phone_minutes IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average bedtime phone use in minutes for each occupation type."
        },
        {
            "query": "SELECT user_id, age, occupation_type, bedtime_phone_minutes, total_sleep_hours FROM bedtime_screentime_sleep_debt WHERE sleep_debt_category = 'Severe Sleep Debt' ORDER BY bedtime_phone_minutes DESC LIMIT 10",
            "description": "Severely sleep-deprived users with the most bedtime phone use."
        },
        {
            "query": "SELECT blue_light_filter_active, AVG(sleep_latency_min) AS avg_latency, AVG(deep_sleep_pct) AS avg_deep_sleep_pct, COUNT(*) AS users FROM bedtime_screentime_sleep_debt GROUP BY 1 ORDER BY 1",
            "description": "Compares sleep latency and deep sleep with and without a blue light filter."
        },
        {
            "query": "SELECT gender, MIN(total_sleep_hours) AS min_sleep, AVG(total_sleep_hours) AS avg_sleep, MAX(total_sleep_hours) AS max_sleep FROM bedtime_screentime_sleep_debt WHERE total_sleep_hours IS NOT NULL GROUP BY 1",
            "description": "Lowest, average, and highest sleep hours by gender."
        },
        {
            "query": "SELECT chronotype, sleep_debt_category, COUNT(*) AS users FROM bedtime_screentime_sleep_debt WHERE chronotype = 'Night Owl' GROUP BY 1, 2 ORDER BY 3 DESC",
            "description": "How Night Owls are spread across sleep debt categories."
        },
        {
            "query": "SELECT primary_bedtime_app, AVG(morning_alarm_snoozes) AS avg_snoozes, AVG(next_day_fatigue_score) AS avg_fatigue FROM bedtime_screentime_sleep_debt WHERE primary_bedtime_app = 'TikTok / Reels' OR primary_bedtime_app = 'YouTube' GROUP BY 1",
            "description": "Snoozes and fatigue for TikTok/Reels versus YouTube bedtime users."
        }
    ]
}