Assignment

1. List OrderIDs and the associated Employee Names for orders that shipped after the required date.

(Hint: Employees to Orders is a one-to-many relationship. So JOIN the two table Employees and Orders and have the WHERE clause filter orders with ShippedDate > RequiredDate)

2. List Products (ProductID, ProductName) and their Suppliers (SupplierID, CompanyName)

(Hint: Suppliers and Products have one-to-many relationship, so JOIN the two table Suppliers and Products)

3. List all Customers (CustomerID, CompanyName) and their Orders (OrderID, OrderedDate)

(Hint: Customers and Orders have one-to-many relationship, and since all Customers is mentioned which means you need to do a LEFT OUTER JOIN)

4. List Customers (CustomerID, CompanyName) and Orders (OrderID, OrderedDate) including the ones they have not placed

(Hint: Customers and Orders have one-to-many relatinship, and since all Orders is mentioned which means you need to do a RIGHT OUTER JOIN)

5. List all Categories (CategoryID, CategoryName) and all Products (ProductID, ProductName)

(Hint: Categories and Products have one-to-many relationship, and since all Categories and all Products is mentioned do a FULL OUTER JOIN)