Orders above the average
easyOrders above the average
Walmart SQL Interview Question
Walmart's finance team wants to review online orders that are bigger than a typical order.
List the order_id and amount of every order worth more than the average order. Use every order, whatever its status, to work out the average.
Asked of
- Data Analyst
- Business Analyst
- Product Analyst
- Data Scientist
- ML Engineer
ordersTable35 rows
| Column Name | Type |
|---|---|
| order_id | BIGINT |
| customer_id | BIGINT |
| order_date | DATE |
| status | VARCHAR |
| amount | DOUBLE |
ordersExample Input
| order_id | customer_id | order_date | status | amount |
|---|---|---|---|---|
| 1001 | 1 | 2024-01-05 | completed | 120.5 |
| 1002 | 2 | 2024-01-07 | completed | 2400 |
| 1003 | 1 | 2024-01-11 | completed | 89.99 |
| 1004 | 3 | 2024-01-15 | canceled | 45 |
| 1005 | 4 | 2024-01-18 | completed | 610.75 |
| 1006 | 2 | 2024-01-22 | completed | 1850.25 |
| 1007 | 5 | 2024-01-29 | completed | 3200 |
| 1008 | 1 | 2024-02-02 | refunded | 75 |
| 1009 | 6 | 2024-02-06 | completed | 55.4 |
| 1010 | 3 | 2024-02-09 | completed | 132.6 |
Example Output
| order_id | amount |
|---|---|
| 1002 | 2400 |
| 1006 | 1850.25 |
| 1007 | 3200 |
Explanation
The ten orders in the example average about 857.95. Only orders 1002, 1006 and 1007, worth 2,400, 1,850.25 and 3,200, are above that. Every other order is worth less than the average.
The example above is a small slice of the data. Your query runs against the full tables.
Company
Walmart
Difficulty
easy
Topic
subqueries
Your query
Starting the SQL engine...