데이터 분석 기술 블로그

Product Sales Analysis III _ Medium. LeetCode 본문

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);

'SQL > 문제풀이' 카테고리의 다른 글

Customers Who Bought All Products _ Medium.LeetCode *  (0) 2025.01.06
Consecutive Numbers _ Medium.LeetCode  (0) 2025.01.05
Immediate Food Delivery II _ Medium. LeetCode *  (2) 2025.01.03
Game Play Analysis IV _ Medium. LeetCode *  (0) 2025.01.02
Monthly Transactions I _ Medium. LeetCode *  (0) 2025.01.01
'SQL/문제풀이' Related Articles more