1070. Product Sales Analysis III.md

1070. Product Sales Analysis III

Question Link

Solution

# Write your MySQL query statement below
select s.product_id, s.year first_year, s.quantity, s.price from Sales s
where (s.product_id, s.year) in (
  select s.product_id, min(s.year) from Sales s group by s.product_id
)