# Walmart Inventory Status — SQL Interview Question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3075/walmart-inventory-status
Source observed: 2026-11-04T23:34:31.301Z
Last checked: 2026-11-04T23:34:31.301+00:00
Indexed: 2026-11-06T16:09:00.776+00:00

---

# Walmart Inventory Status

We provide this medium-difficulty SQL interview question as part of our coding-question library. It concerns **Walmart**, a large retail chain selling products ranging from electronics to groceries. The scenario uses Walmart's product and sales data to identify products with no recorded sales.

## Problem

You are given two tables: `products` and `sales`.

### `products`

| Column | Type |
|---|---|
| `product_id` | integer |
| `product_name` | string |
| `category` | string |

### `sales`

| Column | Type |
|---|---|
| `sale_id` | integer |
| `product_id` | integer |
| `quantity_sold` | integer |
| `sale_date` | date |

Write a SQL query that returns every product and marks whether it has been sold.

The output must contain:

| Column | Allowed values |
|---|---|
| `product_id` | Product identifier |
| `product_name` | Product name |
| `sale_status` | `Sold` or `Not Sold` |

The result must include products that have no matching record in `sales`, with `sale_status` set to `Not Sold`.

## Page features

- Difficulty: **Medium**
- Category: [Coding](https://www.aced.io/questions?type=coding)
- Subcategory: [SQL](https://www.aced.io/questions?type=sql)
- The question is associated with one coding interview and was last asked 3 years ago in the rendered question details.
- Community answers: none contributed yet.
- The solution tab, editor, output panel, and test-results panel are available in the interface, but running code requires an account.

[Sign up to run code](https://www.aced.io/signup?src=lesson) · [Upgrade](https://www.aced.io/upgrade?src=questions)

## Related Aced resources

We offer interview preparation across Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, and Data Engineering, as well as additional courses including AI Engineering, Investment Banking, Generative AI, Security Engineer, TPM, Solutions Architect, UX / Product Design, and BizOps & Strategy.

- [All Questions](https://www.aced.io/questions)
- [SQL Questions](https://www.aced.io/questions?type=sql)
- [Coding Questions](https://www.aced.io/questions?type=algorithms&filterBy=codeEditor&src=nav)
- [Courses](https://www.aced.io/courses?src=nav)
- [Practice](https://www.aced.io/practice?src=nav)
- [Log in](https://www.aced.io/login?src=nav)
- [Sign up](https://www.aced.io/signup?src=nav)

Aced is formerly Exponent.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3075%2Fwalmart-inventory-status&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3075%2Fwalmart-inventory-status). Opening a form does not execute a tool.