TSQL Challenge 29 - Reorganize sales data by sales amount
This challenge presents a tough task of reorganizing the data in a sales table. The table is not normalized correctly and the sales detail data of three items are stored in each row.
Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.