Write SQL and Python, run instantly in your browser, and track your progress.
You are a Global Revenue Analyst at Netflix. The team needs to analyze regional performance to optimize content investment and expansion strategies. Using captured subscription payments from the last 90 days, your task is to determine which geographic regions are driving the highest revenue growth. This analysis informs Netflix's regional content production budgets, local partnership decisions, and market prioritization for new feature rollouts.
| Column Name | Type |
|---|---|
| payment_id | INTEGER |
| user_id | INTEGER |
| subscription_id | INTEGER |
You are a Global Revenue Analyst at Netflix. The team needs to analyze regional performance to optimize content investment and expansion strategies. Using captured subscription payments from the last 90 days, your task is to determine which geographic regions are driving the highest revenue growth. This analysis informs Netflix's regional content production budgets, local partnership decisions, and market prioritization for new feature rollouts.
| Column Name | Type |
|---|---|
| payment_id | INTEGER |
| user_id | INTEGER |
| subscription_id | INTEGER |
| payment_time |
| payment_time |
| TEXT |
| TEXT |
| amount | REAL |
| amount | REAL |
| currency | TEXT |
| currency | TEXT |
| method | TEXT |
| method | TEXT |
| status | TEXT |
| status | TEXT |
| processor | TEXT |
| processor | TEXT |
| transaction_ref | TEXT |
| transaction_ref | TEXT |
| payment_id | user_id | subscription_id | payment_time | amount | currency | method | status | processor | transaction_ref |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 58 | 1 | 2025-07-31T00:00:00 | 17.78 |
| payment_id | user_id | subscription_id | payment_time | amount | currency | method | status | processor | transaction_ref |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 58 | 1 | 2025-07-31T00:00:00 | 17.78 |
| Column Name | Type |
|---|---|
| subscription_id | INTEGER |
| user_id | INTEGER |
| plan_id | INTEGER |
| start_date | TEXT |
| end_date | TEXT |
| status | TEXT |
| Column Name | Type |
|---|---|
| subscription_id | INTEGER |
| user_id | INTEGER |
| plan_id | INTEGER |
| start_date | TEXT |
| end_date | TEXT |
| status | TEXT |
| subscription_id | user_id | plan_id | start_date | end_date | status | auto_renew |
|---|---|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | active | 1 | |
| 2 |
| subscription_id | user_id | plan_id | start_date | end_date | status | auto_renew |
|---|---|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | active | 1 | |
| 2 |
| Column Name | Type |
|---|---|
| plan_id | INTEGER |
| plan_code | TEXT |
| plan_name | TEXT |
| plan_type | TEXT |
| region | TEXT |
| currency | TEXT |
| Column Name | Type |
|---|---|
| plan_id | INTEGER |
| plan_code | TEXT |
| plan_name | TEXT |
| plan_type | TEXT |
| region | TEXT |
| currency | TEXT |
| plan_id | plan_code | plan_name | plan_type | region | currency | monthly_price | max_screens | quality | is_active |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PLN00001 | Basic (SD) | basic | US |
| plan_id | plan_code | plan_name | plan_type | region | currency | monthly_price | max_screens | quality | is_active |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PLN00001 | Basic (SD) | basic | US |
| region | total_revenue | revenue_rank |
|---|---|---|
| EU | 1426.47 | 1 |
| US | 1287.44 | 2 |
| APAC | 1139.6 | 3 |
| LATAM | 1121.67 | 4 |
| NA | 972.44 | 5 |
| region | total_revenue | revenue_rank |
|---|---|---|
| EU | 1426.47 | 1 |
| US | 1287.44 | 2 |
| APAC | 1139.6 | 3 |
| LATAM | 1121.67 | 4 |
| NA | 972.44 | 5 |
5 rows returned.
5 rows returned.
Output Requirements:
Business Logic:
Data Scope & Filters:
Output Requirements:
Business Logic:
Data Scope & Filters:
| USD |
| USD |
| google_pay |
| google_pay |
| captured |
| captured |
| stripe |
| stripe |
| TXN00000001 |
| TXN00000001 |
| 2 | 41 | 2 | 2025-03-17T00:00:00 | 13.31 | USD | google_pay | captured | braintree | TXN00000002 |
| 2 | 41 | 2 | 2025-03-17T00:00:00 | 13.31 | USD | google_pay | captured | braintree | TXN00000002 |
| 3 | 41 | 2 | 2025-04-19T00:00:00 | 13.64 | USD | paypal | refunded | adyen | TXN00000003 |
| 3 | 41 | 2 | 2025-04-19T00:00:00 | 13.64 | USD | paypal | refunded | adyen | TXN00000003 |
| 4 | 41 | 2 | 2025-05-16T00:00:00 | 19.92 | USD | paypal | captured | internal | TXN00000004 |
| 4 | 41 | 2 | 2025-05-16T00:00:00 | 19.92 | USD | paypal | captured | internal | TXN00000004 |
| 5 | 44 | 3 | 2025-06-28T00:00:00 | 16.1 | USD | paypal | chargeback | braintree | TXN00000005 |
| 5 | 44 | 3 | 2025-06-28T00:00:00 | 16.1 | USD | paypal | chargeback | braintree | TXN00000005 |
| auto_renew | INTEGER |
| auto_renew | INTEGER |
| 41 |
| 41 |
| 11 |
| 11 |
| 2025-03-15 |
| 2025-03-15 |
| 2025-05-29 |
| 2025-05-29 |
| canceled |
| canceled |
| 0 |
| 0 |
| 3 | 44 | 10 | 2025-06-28 | 2025-08-04 | canceled | 0 |
| 3 | 44 | 10 | 2025-06-28 | 2025-08-04 | canceled | 0 |
| 4 | 2 | 2 | 2025-02-27 | 2025-07-25 | expired | 0 |
| 4 | 2 | 2 | 2025-02-27 | 2025-07-25 | expired | 0 |
| 5 | 55 | 3 | 2025-07-10 | active | 1 |
| 5 | 55 | 3 | 2025-07-10 | active | 1 |
| monthly_price | REAL |
| monthly_price | REAL |
| max_screens | INTEGER |
| max_screens | INTEGER |
| quality | TEXT |
| quality | TEXT |
| is_active | INTEGER |
| is_active | INTEGER |
| USD |
| USD |
| 6.99 |
| 6.99 |
| 1 |
| 1 |
| sd |
| sd |
| 1 |
| 1 |
| 2 | PLN00002 | Standard (HD) | standard | US | USD | 12.99 | 2 | hd | 1 |
| 2 | PLN00002 | Standard (HD) | standard | US | USD | 12.99 | 2 | hd | 1 |
| 3 | PLN00003 | Premium (UHD) | premium | US | USD | 17.99 | 4 | uhd | 1 |
| 3 | PLN00003 | Premium (UHD) | premium | US | USD | 17.99 | 4 | uhd | 1 |
| 4 | PLN00004 | Ads (4K) | ads | US | USD | 9.99 | 4 | 4k | 1 |
| 4 | PLN00004 | Ads (4K) | ads | US | USD | 9.99 | 4 | 4k | 1 |
| 5 | PLN00005 | Basic (SD) | basic | EU | USD | 7.69 | 1 | sd | 1 |
| 5 | PLN00005 | Basic (SD) | basic | EU | USD | 7.69 | 1 | sd | 1 |
Sorting Requirements:
Sorting Requirements: