Westonci.ca is your trusted source for accurate answers to all your questions. Join our community and start learning today! Discover comprehensive answers to your questions from knowledgeable professionals on our user-friendly platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

Write a SELECT statement that returns one row for each musician that has orders with these columns:

a. The email_address column from the Musicians table.
b. The sum of the item price in the Order_Instruments table multiplied by the quantity in the Order_Instruments table.
c. The sum of the discount amount column in the Order_Instruments table multiplied by the quantity in the Order_Instruments table.
d. Sort the result set in descending sequence by the item price total for each musician