Product Sales Analysis I
Amazon
Problem Statement
To improve business reporting, you need to enrich raw sales data with descriptive names for each item sold.
Write an SQL query to report the product_name, year, and price for each sale_id in the Sales table.
Rules:
- You must retrieve information from both the Sales and Product tables.
- Each row in the output should represent a single sale record.
- The order of the results does not matter.
Tests your understanding of
Basic SQL, Joins, Relational Mapping and Inner Join
Input Tables
sales
| sale_id(INTEGER) | product_id(INTEGER) | year(INTEGER) | quantity(INTEGER) | price(INTEGER) |
|---|---|---|---|---|
| 1 | 100 | 2024 | 10 | 5000 |
| 2 | 100 | 2025 | 12 | 5000 |
| 7 | 200 | 2025 | 15 | 9000 |
| 8 | 300 | 2023 | 5 | 1200 |
| 9 | 100 | 2023 | 2 | 4500 |
| 10 | 200 | 2024 | 20 | 8500 |
product
| product_id(INTEGER) | product_name(VARCHAR) |
|---|---|
| 100 | Echo Dot |
| 200 | Kindle |
| 300 | Fire Stick |
Expected Output
| product_name(VARCHAR) | year(INTEGER) | price(INTEGER) |
|---|---|---|
| Echo Dot | 2024 | 5000 |
| Echo Dot | 2025 | 5000 |
| Kindle | 2025 | 9000 |
| Fire Stick | 2023 | 1200 |
| Echo Dot | 2023 | 4500 |
| Kindle | 2024 | 8500 |
Tags
EasyBasic SQLJoinsRelational MappingInner Join
5-10 min
85%