Product Sales Analysis III.sql

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