Write SQL and Python, run instantly in your browser, and track your progress.
You are a Business Analyst at Costco. The Sales team wants a rolling average that starts calculating from the first order instead of waiting for a full window. Calculate a 3-order rolling average of total_amount with min_periods=1 so that all rows have values.
| Column Name | Type |
|---|---|
| order_id | int64 |
| order_number | object |
| total_amount | float64 |
| status | object |
You are a Business Analyst at Costco. The Sales team wants a rolling average that starts calculating from the first order instead of waiting for a full window. Calculate a 3-order rolling average of total_amount with min_periods=1 so that all rows have values.
| Column Name | Type |
|---|---|
| order_id | int64 |
| order_number | object |
| total_amount | float64 |
| status | object |
| order_id | order_number | total_amount | status |
|---|---|---|---|
| 1 | ORD-001 | 150.00 | delivered |
| 2 | ORD-002 | 200.00 | delivered |
| 3 | ORD-003 | 100.00 |
| order_id | order_number | total_amount | status |
|---|---|---|---|
| 1 | ORD-001 | 150.00 | delivered |
| 2 | ORD-002 | 200.00 | delivered |
| 3 | ORD-003 | 100.00 |
| order_id | order_number | total_amount | rolling_avg |
|---|---|---|---|
| 1 | ORD-10001 | 55.32 | 55.32 |
| 2 | ORD-10002 | 662.48 | 358.90 |
| 3 | ORD-10003 | 88.66 | 268.82 |
| 4 | ORD-10004 | 322.87 | 358 |
| order_id | order_number | total_amount | rolling_avg |
|---|---|---|---|
| 1 | ORD-10001 | 55.32 | 55.32 |
| 2 | ORD-10002 | 662.48 | 358.90 |
| 3 | ORD-10003 | 88.66 | 268.82 |
| 4 | ORD-10004 | 322.87 | 358 |
Showing first 5 of 75 rows.
Showing first 5 of 75 rows.
1. Data Selection:
2. Window Function:
3. Output:
1. Data Selection:
2. Window Function:
3. Output:
| shipped |
| shipped |
| 4 | ORD-004 | 250.00 | delivered |
| 4 | ORD-004 | 250.00 | delivered |
| 5 | ORD-005 | 175.00 | shipped |
| 5 | ORD-005 | 175.00 | shipped |
| 5 | ORD-10005 | 629.34 | 346.96 |
| 5 | ORD-10005 | 629.34 | 346.96 |