Orders per calendar month
mediumOrders per calendar month
Walmart SQL Interview Question
Walmart's fulfillment centers plan staff a month ahead, so the operations team wants to see how many online orders arrive each month.
Count the orders placed in each month, whatever their status. Show the first day of the month as order_month, as a date such as 2024-01-01 for January 2024, and the count as order_count. Sort the rows by order_month, earliest first.
Asked of
- Data Analyst
- BI Analyst
- Product Analyst
- Analytics Engineer
- Data 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_month | order_count |
|---|---|
| 2024-01-01 | 7 |
| 2024-02-01 | 3 |
Explanation
Seven orders in the example were placed in January 2024, including one that was canceled, so 2024-01-01 has a count of 7. The remaining three orders were placed in February 2024.
The example above is a small slice of the data. Your query runs against the full tables.
Company
Walmart
Difficulty
medium
Topic
dates
Your query
Starting the SQL engine...