Leetcode Problem 1069. Product Sales Analysis II

1069. Product Sales Analysis II

Leetcode Solutions

Aggregating Total Quantity Sold per Product

Select the product_id and quantity columns from the Sales table.
Group the selected data by product_id to prepare for aggregation.
Use the SUM() function to calculate the total quantity sold for each product_id.
Rename the aggregated quantity column to total_quantity using the AS keyword.
Return the result set with product_id and total_quantity.

erDiagram
    Sales {
        int sale_id
        int product_id
        int year
        int quantity
        int price
    }
    Product {
        int product_id
        varchar product_name
    }
    Sales }|--|| Product : has

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...