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

Product with sales increasing every year

A multinational Company is going through very bad timings and now want to focus on products which has shown increased sales and profit every year. They are looking for your help in identifying such products so that they can plan marketing campaign accordingly. Input Table – Product_sales sale_year product_id units_sold 2016 1 1000 2016 2 … Read more