Write SQL and Python, run instantly in your browser, and track your progress.
You are a Financial Analyst at Netflix. The finance team needs visibility into recent subscription payments for revenue tracking and reconciliation purposes.
Your task is to provide a list of all payments showing the user, subscription, payment time, amount, and status. Sort by the most recent payment time first.
| Column Name | Type |
|---|---|
| payment_id | INTEGER |
| user_id | INTEGER |
| subscription_id | INTEGER |
You are a Financial Analyst at Netflix. The finance team needs visibility into recent subscription payments for revenue tracking and reconciliation purposes.
Your task is to provide a list of all payments showing the user, subscription, payment time, amount, and status. Sort by the most recent payment time first.
| 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 |
| payment_id | user_id | subscription_id | payment_time | amount | status |
|---|---|---|---|---|---|
| 122 | 19 | 60 | 2025-09-01T00:00:00 | 12.27 | failed |
| 7 | 44 | 3 | 2025-08-30T00:00:00 | 7.49 | captured |
| 19 | 52 |
| payment_id | user_id | subscription_id | payment_time | amount | status |
|---|---|---|---|---|---|
| 122 | 19 | 60 | 2025-09-01T00:00:00 | 12.27 | failed |
| 7 | 44 | 3 | 2025-08-30T00:00:00 | 7.49 | captured |
| 19 | 52 |
Showing first 5 of 157 rows. Streaming payments sorted by most recent payment time.
Showing first 5 of 157 rows. Streaming payments sorted by most recent payment time.
1. Output Columns:
2. Filtering:
3. Ordering:
1. Output Columns:
2. Filtering:
3. Ordering:
| 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 |
| 8 |
| 8 |
| 2025-08-30T00:00:00 |
| 2025-08-30T00:00:00 |
| 7.96 |
| 7.96 |
| authorized |
| authorized |
| 88 | 12 | 46 | 2025-08-29T00:00:00 | 8.3 | captured |
| 88 | 12 | 46 | 2025-08-29T00:00:00 | 8.3 | captured |
| 39 | 25 | 18 | 2025-08-27T00:00:00 | 9.35 | captured |
| 39 | 25 | 18 | 2025-08-27T00:00:00 | 9.35 | captured |