Welcome to Westonci.ca, where finding answers to your questions is made simple by our community of experts. Get immediate and reliable answers to your questions from a community of experienced professionals on our platform. Get quick and reliable solutions to your questions from a community of experienced experts on our 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

Sagot :

Answer:

no this question have some mistakes