<invoke name="query_sql"> <parameter name="sql">WITH b AS (SELECT MIN(total_sleep_hours) AS lo, MAX(total_sleep_hours) AS hi FROM raw.bedtime_screentime_sleep_debt) SELECT CASE WHEN s.total_sleep_hours = b.lo THEN 'lowest' ELSE 'highest' END AS extreme, s.total_sleep_hours, COUNT(*) AS users, AVG(next_day_fatigue_score) AS avg_fatigue, AVG(sleep_latency_min) AS avg_latency_min, AVG(caffeine_post_5pm_mg) AS avg_caffeine_mg, AVG(morning_alarm_snoozes) AS avg_snoozes, AVG(deep_sleep_pct) AS avg_deep_pct, AVG(rem_sleep_pct) AS avg_rem_pct, AVG(bedtime_phone_minutes) AS avg_phone_min FROM raw.bedtime_screentime_sleep_debt s, b WHERE s.total_sleep_hours IN (b.lo, b.hi) GROUP BY 1, 2 ORDER BY 2</parameter> <parameter name="purpose">Ground the lowest and highest total_sleep_hours records: how many users sit at each extreme and their average profile</parameter> <parameter name="source">raw</parameter> </invoke> <parameter name="args">{}</parameter>