1. Write a SQL Statement to create a View called vwEmployeeTerritories that will do the following: Return all Employees and their Territories (use INNER JOIN). Show the Employee Name and the Territory Description in the result set. Test the view that it properly works.
2. Write a query that will use the vwEmployeeTerritories view to select all employees who are in the following territories: Bedford, Boston, Wilton. Us an IN statement in association with a WHERE clause to do this.
3. Write a SQL statement to create a view called vwOrdersShipped that will do the following: Return all Orders for each shipper (use INNER JOIN).
· Return the data in the following format:
ShipperID
CompanyName
Phone
OrderID
CustomerID
ShippedDate
4. Write a query that will use the vwOrdersShipped view and joins to the [Order Details] table to show the detailed items in each order (use INNER JOIN).
5. Write a query that uses the vwOrdersShipped view and formats the resulting ShippedDate as dd/mm/yyyy (May 16th, 2001 would be formatted as 16/05/2001).