Reference no: EM13674871

Problem #1

Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

Problem #2

Display the CustomerID, and customer's name (show the customer's name as the LastName concatenated to the FirstName separated by a comma and a space). Only show those customers that have the word/partial word "mail" somewhere in the EmailAddress. Order the results by the customer's last name in ascending order.

Problem #3

Display all the LastNames from the Customers table and any associated OrdersIDs from the Orders Table. Show the LastName even if they do not have any associated orders. Order the results by LastName in ascending order.

Problem #4

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.

Problem #5

Display the LastNames from the Customers table and the OrderIDs from the Orders table for all orders that have a ShipAmount that is greater than the average ShipAmount for all Orders. (**Solve using a subquery).