Product Sales Analysis I.sql

-- Problem Statement: Write a solution to report the product_name, year, and price for each sale_id in the Sales table.

-- Given Table: Sales
-- 
-- +-------------+-------+
-- | Column Name | Type  |
-- +-------------+-------+
-- | sale_id     | int   |
-- | product_id  | int   |
-- | year        | int   |
-- | quantity    | int   |
-- | price       | int   |
-- +-------------+-------+
-- (sale_id, year) is the primary key (combination of columns with unique values) of this table.
-- product_id is a foreign key (reference column) to the Product table.
-- Each row of this table shows a sale on the product product_id in a certain year.
-- Note that the price is per unit.
-- 
-- Given Table: Product
-- 
-- +--------------+---------+
-- | Column Name  | Type    |
-- +--------------+---------+
-- | product_id   | int     |
-- | product_name | varchar |
-- +--------------+---------+
-- product_id is the primary key (column with unique values) of this table.
-- Each row of this table indicates the product name of each product.
-- 
-- Approach: To report the product_name, year, and price for each sale_id in the Sales table, we can perform a LEFT JOIN between the Sales table and the Product table on the product_id column.
-- 
-- SQL Solution:
SELECT product_name, year, price
FROM Sales
LEFT JOIN Product ON Product.product_id = Sales.product_id;