A. Show the Last Name, First Name, and Phone of all customers who have had an order with an Item named 'Dress Shirt'. Use a join, but do not use JOIN ON syntax. Present results sorted by Last Name in ascending order and then First Name in descending order.
B. Show the Last Name, First Name, and Phone of all customers who have had an order with an Item named 'Dress Shirt'. Use a join using JOIN ON syntax. Present results sorted by Last Name in ascending order and then First Name in descending order.
C. Show the Last Name, First Name, and Phone of all customers who have had an order with an Item named 'Dress Shirt'. Use a combination of a join using JOIN ON syntax and a sub query. Present results sorted by Last Name in ascending order and then First Name in descending order.
D. Show the Last Name, First Name, Phone, and Total Amount of all customer orders that included an Item named 'Dress Shirt'. Also show the Last Name, First Name, and Phone of all other customers. Present results sorted by Total Amount in ascending order, then Last Name in ascending order, and then First Name in descending order.