1070. Product Sales Analysis III LeetCode Solution

In this guide, you will get 1070. Product Sales Analysis III LeetCode Solution with the best time and space complexity. The solution to Product Sales Analysis III problem is provided in various programming languages like C++, Java, and Python. This will be helpful for you if you are preparing for placements, hackathons, interviews, or practice purposes. The solutions provided here are very easy to follow and include detailed explanations.

Problem Statement
Complexity Analysis
Product Sales Analysis III solution in C++
Product Sales Analysis III solution in Java
Product Sales Analysis III solution in Python
Additional Resources

1070. Product Sales Analysis III LeetCode Solution image

Problem Statement of Product Sales Analysis III

Table: Sales

+————-+——-+
| Column Name | Type |
+————-+——-+
| sale_id | int |
| product_id | int |
| year | int |
| quantity | int |
| price | int |
+————-+——-+
(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

Write a solution to select the product id, year, quantity, and price for the first year of every product sold.
Return the resulting table in any order.
The result format is in the following example.

Example not found

Constraints not found

Complexity Analysis

Time Complexity: Google AdSense
Space Complexity: Google Analytics

1070. Product Sales Analysis III LeetCode Solution in C++

WITH
  ProductToYear AS (
    SELECT product_id, MIN(year) AS year
    FROM Sales
    GROUP BY 1
  )
SELECT
  Sales.product_id,
  ProductToYear.year AS first_year,
  Sales.quantity,
  Sales.price
FROM Sales
INNER JOIN ProductToYear
  USING (product_id, year);
/* code provided by PROGIEZ */