Display the CustomerID from the Orders table and the sum of theassociated ItemPr

Display the CustomerID from the Orders table and the sum of theassociated ItemPrice multiplied by Quantity using Gross Sales (witha space) as the column name from the OrderItems table. Only showthose orders where the Gross Sales is more than $500.00. Displaythe results in descending order by the gross sales.