Question d’entretien chez Amazon
Write a SQL to explode the data from orders table based on quantity ordered for each product Ex: A product book if ordered with quantity 3, Then i should get the output as 3 rows with each record having quantity 1.
Write a SQL to explode the data from orders table based on quantity ordered for each product Ex: A product book if ordered with quantity 3, Then i should get the output as 3 rows with each record having quantity 1.