Easy Solution || SQL || For Beginner's Only
Intuition\n Describe your first thoughts on how to solve this problem. \n\n# Approach\n Describe your approach to solving the problem. \n\n# Complexity\n- Time 
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\n\n# Complexity\n- Time complexity:\n<!-- Add your time complexity here, e.g. $$O(n)$$ -->\n\n- Space complexity:\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\n\n# Code\n```mysql []\n \n select product_id,year as first_year,quantity,price from\n (select sale_id,product_id,year,quantity,price,RANK() over(PARTITION by  product_id order by year asc)as rno\n    from  Sales) a where a.rno=1\n\n```
['MySQL']