Product Sales Analysis I

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

Table: Sales

+-------------+------+
| Column Name | Type |
+-------------+------+
| sale_id     | INT  |
| product_id  | INT  |
| year        | INT  |
| quantity    | INT  |
| price       | INT  |
+-------------+------+

Table: Product

+--------------+-------------+
| Column Name  | Type        |
+--------------+-------------+
| product_id   | INT         |
| product_name | varchar(10) |
+--------------+-------------+

Input: Sales table:

+---------+------------+------+----------+-------+
| sale_id | product_id | year | quantity | price |
+---------+------------+------+----------+-------+
| 1       | 100        | 2008 | 10       | 5000  |
| 2       | 100        | 2009 | 12       | 5000  |
| 7       | 200        | 2011 | 15       | 9000  |
+---------+------------+------+----------+-------+

Product table:

+------------+--------------+
| product_id | product_name |
+------------+--------------+
| 100        | Nokia        |
| 200        | Apple        |
| 300        | Samsung      |
+------------+--------------+

Output:

+--------------+------+-------+
| product_name | year | price |
+--------------+------+-------+
| Nokia        | 2008 | 5000  |
| Nokia        | 2009 | 5000  |
| Apple        | 2011 | 9000  |
+--------------+------+-------+