proj 2

 1. Use INNER JOIN to create a query result. In this query result, list each vendor’s name and the name of each product the vendor has supplied to our company. You should use the Vendors, Product_Vendors, and the Products tables in the database to complete this task. (20 Points) 

2. Use INNER JOIN to create a query result. In this query result, list each customer’s first name, last name, and the dates when he or she places orders to us. You should use the Orders table and the Customers table in the database to complete this task. (20 Points) 

3. Use OUTER JOIN to create a query result. In this query result, list the name of the products that have never been ordered. You should use the Order_Details table and the Products table in the database to complete this task. (20 Points) 

4. Use UNION to create a query result. In this query result, list both customers’ and employees’ first name, last name, street address, city of residence, state of residence, and zip code. You should use the Customers table and the Employees table in the database to complete this task. (20 Points)

 5. Count the number of Customers. You should use the Customers table. (10 Points) 

6. Use MAX in a query. You can use any table. (10 Points)