Question: Display the Customer and State from the Addresses table for all addresses located in Florida, followed by those customers located in Georgia using a
Display the Customer and State from the Addresses table for all addresses located in Florida, followed by those customers located in Georgia using a SET operator. Problem #8: Display the CustomerID and the # of Order's for each customer. Use an appropriate alias for the summary column. Problem #9: Display OrderID's from the Orders table and the orders values of the associated OrderItems's from the Orderltems table. Only show those orders where the order value is more than $300 Order the results in descending order by the sum of the order values. Hint: [order value - (Itemprice"Quantity)-Discount Amount] Problem #10: Use a correlated subquery to return one row per customer, representing the customer's oldest order (the one with the earliest date). Each row should include these three columns: EmailAddress. OrderID, and OrderDate.
Step by Step Solution
3.50 Rating (153 Votes )
There are 3 Steps involved in it
Problem 8 sql SELECT CustomersCustomerID COUNTOrdersOrderID AS NumberOfOrders FROM Customers JOIN Or... View full answer
Get step-by-step solutions from verified subject matter experts
