1070. Product Sales Analysis III

1070. Product Sales Analysis III

문제

1. 모든 제품이 판매된 첫 번째 연도를 기준으로 product_id , year, quantity, price
2. any order

입력 테이블

1. Sales
   • sale_id
   • product_id
   • year
   • quantity
   • price
2. Product
   • product_id
   • product_name

풀이

1. product_id별 최소 연도 구하기

product_id별 year 최소연도 구하기

select product_id, min(year) as first_year
from Sales
group by product_id

2. 조건절 사용

product_id와 year와 맞는 데이터 가져오기

select product_id, year as first_year, quantity, price
from Sales
where (product_id, year) in (
select product_id, min(year) as first_year
from Sales
group by product_id)