You have to write a query to display customer id from the order table associated with order id in given database.
Display the CustomerID from the Orders table and the sum of the associated ItemPrice multiplied by Quantity using Gross Sales (with a space) as the column name from the OrderItems table. Only show those orders where the Gross Sales is more than $500.00.
Display the results in descending order by the gross sales.