Sales Analysis: Specific Product
ASKED IN INTERVIEWApple
Problem Statement
Apple marketing wants to target "iPhone-only" users with a special MacBook promotion.
Write an SQL query to find all buyer_id values for users who have bought the product named iPhone but have never bought the product named MacBook.
Rules:
- The product names are case-sensitive.
- Output columns: buyer_id.
- Results must be sorted by buyer_id in ascending order.
Tests your understanding of
Subqueries, Set Operations and Filtering
Input Tables
sales
| sale_id(INTEGER) | product_id(INTEGER) | buyer_id(INTEGER) | sale_date(DATE) |
|---|---|---|---|
| 1 | 101 | 1 | 2026-01-01 |
| 2 | 101 | 2 | 2026-01-02 |
| 3 | 102 | 2 | 2026-01-03 |
| 4 | 101 | 3 | 2026-01-04 |
products
| product_id(INTEGER) | product_name(VARCHAR) |
|---|---|
| 101 | iPhone |
| 102 | MacBook |
| 103 | AirPods |
product_category
| product_id(INTEGER) | category(VARCHAR) |
|---|---|
| 101 | Mobile |
| 102 | Laptop |
Expected Output
| buyer_id(INTEGER) |
|---|
| 1 |
| 3 |
Tags
EasyASKED IN INTERVIEWSubqueriesSet OperationsFiltering
10-15 min
68%