Sales Analysis – 1

Tables – product and sales are provided. Being area manager, you are looking for best seller by total sales price to reward and motivate them for best results. If there is a tie, all sellers would be qualified for same reward. Write SQL query to fetch all seller_id by total sale price. Input Table: sales … Read more

Sales Analysis – 2

Tables – product and sales are provided. product table holds data of all products and sales table represent sale transaction that was completed. Write SQL query to identify buyer_id who bought S10 but not iPhone. Input Table: sales seller_id product_id buyer_id sale_date quantity price 11 10 71 2019-02-22 3 6000 11 20 72 2019-03-27 1 600 … Read more