SQL/문제풀이

Product Sales Analysis III _ Medium. LeetCode

데이터분석가 이채은 2025. 1. 4. 21:12 

SELECT product_id,
    year AS first_year,
    quantity,
    price
FROM Sales
WHERE (product_id, year) IN 
    (SELECT product_id, MIN(year) FROM Sales GROUP BY product_id);