1069 Product Sales Analysis II

Description

Table: 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.

Table: Product

• 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.

Problem Statement

Write a solution that reports the total quantity sold for every product id.

Return the resulting table in any order.

The result format is in the following example.

Example 1:

Input:

• Sales table:

• Product table:

Output:

Solution

In this problem, for each product_id, we need to find the total quantity sold. The quantity column from Sales table might be used to find the total quantity for each product. In order to find total quantity, you need to group by the product_id and sum the quantity column.

1SELECT product_id, SUM(quantity) total_quantity
2    FROM Sales
3    GROUP BY product_id;