LeetCode 1069. Product Sales Analysis II

Description

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

SQL Schema

Table: Sales

+-------------+-------+
| Column Name | Type  |
+-------------+-------+
| sale_id     | int   |
| product_id  | int   |
| year        | int   |
| quantity    | int   |
| price       | int   |
+-------------+-------+
sale_id 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 total quantity sold for every product id.

The query result format is in the following example:

Sales

Explanation

GROUP BY and SUM().

SQL Solution

# Write your MySQL query statement below
select Product.product_id as product_id, sum(quantity) as total_quantity from Sales join Product on Sales.product_id = Product.product_id group by Product.product_id

Leave a Reply

Your email address will not be published.