LeetCode 1068. Product Sales Analysis I

Description

https://leetcode.com/problems/product-sales-analysis-i/

SQL Schema

Table: Sales

+-------------+-------+
| Column Name | Type  |
+-------------+-------+
| sale_id     | int   |
| product_id  | int   |
| year        | int   |
| quantity    | int   |
| price       | int   |
+-------------+-------+
(sale_id, year) is the primary key of this table.
product_id is a foreign key to Product table.
Note that the price is per unit.

Table: Product

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| product_id   | int     |
| product_name | varchar |
+--------------+---------+
product_id is the primary key of this table.

Write an SQL query that reports the product_name, year, and price for each sale_id in the Sales table.

Return the resulting table in any order.

The query result format is in the following example:

Sales

Explanation

Simply join two tables.

SQL Solution

# Write your MySQL query statement below
select product_name, year, price from Sales join Product on Sales.product_id = Product.product_id