This Leetcode problem Product Sales Analysis II LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Product Sales Analysis II LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Product Sales Analysis II LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
sale_id | int |
product_id | int |
year | int |
quantity | int |
price | int |
Sales
(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.
Column Name | Type |
product_id | int |
product_name | varchar |
Product
product_id is the primary key of this table.
Write an SQL query that reports the total quantity sold for every product id.
The result format is in the following example.
sale_id | product_id | year | quantity | price |
1 | 100 | 2008 | 10 | 5000 |
2 | 100 | 2009 | 12 | 5000 |
7 | 200 | 2011 | 15 | 9000 |
product_id | product_name |
100 | Nokia |
200 | Apple |
300 | Samsung |
Output:
product_id | total_quantity |
100 | 22 |
200 | 15 |
Product Sales Analysis II LeetCode Solution MySQL
select
product_id,
sum(quantity) as total_quantity
from
Sales
group by
product_id;
Code language: SQL (Structured Query Language) (sql)