Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Analyst at Amazon. The Sales team wants to identify top orders by value. Rank all orders by their total_amount in descending order (highest amount gets rank 1).
| Column Name | Type |
|---|---|
| order_id | int64 |
| order_number | object |
| customer_id | int64 |
| total_amount | float64 |
You are a Data Analyst at Amazon. The Sales team wants to identify top orders by value. Rank all orders by their total_amount in descending order (highest amount gets rank 1).
| Column Name | Type |
|---|---|
| order_id | int64 |
| order_number | object |
| customer_id | int64 |
| total_amount | float64 |
| status | object |
| status | object |
| order_id | order_number | customer_id | total_amount | status |
|---|---|---|---|---|
| 1 | ORD-001 | 101 | 249.99 | delivered |
| 2 | ORD-002 | 102 | 89.50 | shipped |
| order_id | order_number | customer_id | total_amount | status |
|---|---|---|---|---|
| 1 | ORD-001 | 101 | 249.99 | delivered |
| 2 | ORD-002 | 102 | 89.50 | shipped |
| order_id | order_number | total_amount | amount_rank |
|---|---|---|---|
| 22 | ORD-10022 | 2733.32 | 1 |
| 48 | ORD-10048 | 2111.92 | 2 |
| 67 | ORD-10067 | 2034.68 | 3 |
| 30 | ORD-10030 | 1917.24 | 4 |
| order_id | order_number | total_amount | amount_rank |
|---|---|---|---|
| 22 | ORD-10022 | 2733.32 | 1 |
| 48 | ORD-10048 | 2111.92 | 2 |
| 67 | ORD-10067 | 2034.68 | 3 |
| 30 | ORD-10030 | 1917.24 | 4 |
Showing first 5 of 75 rows.
Showing first 5 of 75 rows.
1. Data Selection:
2. Ranking:
3. Output:
1. Data Selection:
2. Ranking:
3. Output:
| 3 |
| 3 |
| ORD-003 |
| ORD-003 |
| 103 |
| 103 |
| 324.00 |
| 324.00 |
| delivered |
| delivered |
| 4 | ORD-004 | 104 | 249.99 | canceled |
| 4 | ORD-004 | 104 | 249.99 | canceled |
| 5 | ORD-005 | 105 | 189.99 | delivered |
| 5 | ORD-005 | 105 | 189.99 | delivered |
| 13 | ORD-10013 | 1823.70 | 5 |
| 13 | ORD-10013 | 1823.70 | 5 |