Write a query to display customer id from the order table


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.

 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Write a query to display customer id from the order table
Reference No:- TGS0961273

Expected delivery within 24 Hours