Hi Parvesh, Thank you so much for paving the path, Sorry for the misunderstanding actually now I don't have to calculate the total amount(amount*quantity). The amount column has the total amount data. Now I have to sum the amount of all purchases by a particular customer and put group by on the cust...