[LeetCode] 1070. Product Sales Analysis III

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH first_year AS (
    SELECT product_id
        , MIN(year) AS year
    FROM Sales
    GROUP BY product_id
)

SELECT s.product_id
     , f.year AS first_year
     , s.quantity
     , s.price
FROM Sales AS s
    LEFT JOIN first_year AS f ON s.product_id = f.product_id
WHERE s.year = f.year