SQL · Netflix · Medium
Write a PostgreSQL query that reports daily activity and next-day retention over a fixed UTC date range: 2025-05-26 through 2025-06-01, inclusive. The query must return exactly one row per calendar day in that range, ordered by day, even when a day has no activity. The graded deliverable is one PostgreSQL result set; a high-level pandas outline is optional discussion. Each row must contain these columns: day (DATE), dau, new_users, d1_retention_rate, and revenue_per_dau.…
Checking your access…