Leetcode Problem 1068. Product Sales Analysis I

1068. Product Sales Analysis I

Leetcode Solutions

Key approach of the solution

Perform an inner join between the Sales and Product tables using the product_id column as the join key.
Select the product_name from the Product table.
Select the year and price columns from the Sales table.
The resulting table will contain the combined information of product_name, year, and price for each sale_id.

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

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