# Product Sales Analysis I LeetCode Solution

This Leetcode problem Product Sales Analysis I LeetCode Solution is done in SQL.

# List of all LeetCode Solution

## Problem Statement

(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 `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.

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.

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

Return the resulting table in any order.

The result format is in the following example.

Example 1:
Input:

Output:

Explanation: From sale_id = 1, we can conclude that Nokia was sold for 5000 in the year 2008. From sale_id = 2, we can conclude that Nokia was sold for 5000 in the year 2009. From sale_id = 7, we can conclude that Apple was sold for 9000 in the year 2011.

## Product Sales Analysis I LeetCode Solution MySQL

``````select
distinct P.product_name,
S.year,
S.price
from
(
select
distinct product_id,
year,
price
from
Sales
) S
inner join Product as P using (product_id);```Code language: SQL (Structured Query Language) (sql)```

## Product Sales Analysis I LeetCode Solution Pandas

``````import pandas as pd
​
def sales_analysis(sales: pd.DataFrame, product: pd.DataFrame) -> pd.DataFrame:
sales_and_product = sales.merge(
product,
on=["product_id"]
)
df = sales_and_product[['product_name', 'year', 'price']]

return df```Code language: JavaScript (javascript)```
Scroll to Top