write query that returns the CustomerID from the Customers table,
the OrderID from the Orders table, and the total of all orders
(UnitPrice times Quantity) from the OrderLines table. Take a screen
shot of the SQL windows and results and paste it here.
Part 3 Rewrite the query in Part 2, returning the CustomerName
and OrderDate instead of the CustomerID and OrderID, the sales
total for each order, and the total of all orders for the
CustomerName, OrderDate, and order total. Do not use Group By. Take
a screen shot of the SQL windows and results and paste it
here..
The previous answer does NOT work.
- Part 2 Using Wideworldimporters Database And The Sales Schema Write Query That Returns The Customerid From The Customers 1 (59.38 KiB) Viewed 41 times