results of the query.

T$.$ Show the LastName, FirstName, 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 subquery. Present results sorted by LastName in ascending order and then FirstName in descending order.

U$.$ Show the LastName, FirstName, Phone, and TotalAmount of all customer orders that included an Item named 'Dress Shirt'. Also show the LastName, FirstName, and Phone of all other customers. Present results sorted by TotalAmount in ascending order, then LastName in ascending order, and then FirstName in descending order. HINT: In Microsoft Access $2016,$ you will either need to use a UNION statement or a sequence of two queries to solve this because Microsoft Access disallows nesting an INNER join inside a LEFT OUTER or RIGHT OUTER join. The other DBMS products can complete this question with one query $($not a UNION statement$).$

Us AS For keywords