Display the Customer and State from the Addresses table for all addresses located in Florida, followed...

  

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

Problem 8 sql SELECT CustomersCustomerID COUNTOrdersOrderID AS NumberOfOrders FROM Customers JOIN Or... View the full answer