Last updated on October 10th, 2024 at 12:06 am

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

List of all LeetCode Solution

Product Sales Analysis II 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 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.

Output:

Product Sales Analysis II LeetCode Solution MySQL

select 
  product_id, 
  sum(quantity) as total_quantity 
from 
  Sales 
group by 
  product_id;