Oracle SQL Question:

Write a query that returns three columns for each order: email_address of the customer, order_id, and the order total. To do this, group the result set by the email_address and order_id columns. In addition, you must calculate the order total from the columns in the Order_Items table. (You will not need subqueries to complete this exercise.)

Sort the results in descending sequence by order total.