Find Users with No Orders
ASKED IN INTERVIEWWalmart
Problem Statement
Walmart marketing teams want to reach out to customers who have become inactive. You need to find all customers who have not placed any orders in the last 6 months (relative to today's date, which is 2026-02-08).
A customer is considered inactive if there is no record of an order for them in the system that was placed on or after 2025-08-08.
Rules:
- Include customers who have never placed an order at all.
- Output columns: customer_id, customer_name.
- Results must be sorted by customer_id in ascending order.
Tests your understanding of
Left Join, Filtering and Date Functions
Input Tables
customers
| customer_id(INTEGER) | customer_name(VARCHAR) | email(VARCHAR) |
|---|---|---|
| 1 | Alice Smith | [email protected] |
| 2 | Bob Johnson | [email protected] |
| 3 | Charlie Brown | [email protected] |
| 4 | David Miller | [email protected] |
| 5 | Eve Adams | [email protected] |
orders
| order_id(INTEGER) | customer_id(INTEGER) | order_date(DATE) |
|---|---|---|
| 101 | 1 | 2026-01-15 |
| 102 | 2 | 2024-12-01 |
| 103 | 3 | 2025-09-20 |
| 104 | 5 | 2023-01-01 |
customer_segments
| customer_id(INTEGER) | segment_name(VARCHAR) |
|---|---|
| 1 | Premium |
| 2 | Standard |
| 4 | New |
Expected Output
| customer_id(INTEGER) | customer_name(VARCHAR) |
|---|---|
| 2 | Bob Johnson |
| 4 | David Miller |
| 5 | Eve Adams |
Tags
EasyASKED IN INTERVIEWLeft JoinFilteringDate Functions
10-15 min
75%