SQL:

- List the customers information for customers who HAVE NOT put in an order. Use an outer join.

- Create a listing of an employees full name (First name space Last Name) and the full name of the person they report to (Supervisor). This is a self-join. If an employee does not report to anyone, they should not appear in the result set. Sort the result set supervisors full name and then by the employees last name. Name the columns appropriately.

- This query will need 6 tables. Display the following: Customer ID, customer company name, employee last name who wrote the order, order date, order product name, order product quantity, and the company name of the supplier who provides the product. Only products with a name of Chai, Chang, or Tofu should be included. It should only be for orders written (OrderDate) for the month of December regardless of year use the Month(date field) function.