Your question is SQL for New Netflix Members. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Netflix wants a quick daily measure of member acquisition for its subscription analytics dashboard. Write a PostgreSQL query that counts members who joined during the last 7 calendar days, including today.
members table to records with a joined_on date from CURRENT_DATE - INTERVAL '6 days' through CURRENT_DATE.new_member_count.| Column | Type | Description |
|---|---|---|
| member_idPK | INT | Unique Netflix member identifier |
| member_name | VARCHAR(100) | Member display name |
| joined_on | DATE | Date the member joined Netflix |
| membership_status | VARCHAR(20) | Current membership status |