1070-product-sales-analysis-iii

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

SELECT product_id,year as first_year,quantity,price
FROM(
    SELECT *,
    rank() over(partition by product_id order by year) as r
    FROM Sales
) as t
where r=1