Product Sales Analysis – 3
Write a SQL query that selects the product id, sale year, quantity, and price for the first year of every product sold. Input Table : sales sale_id product_id sale_year quantity price 20 80 2017 21 300 30 80 2018 23 400 40 13 2019 56 600 Output Table: product_id first_year quantity price 80 2017 21 300 13 … Read more