5. Using an inner join, list the EmployeeID, FirstName, and LastName from the employees table and the JobDescription from the jobs table sorted in alphabetical order by LastName. Use the aliases (e and j) for the the employees and jobs tables.

6. Create a query that lists the OrderID, CustomerID, Customer's ContactName, Freight, and CompanyName of the shipper. Only list the orders that are being shipped by "Speedy Express" and have a freight cost over $25.00. Use a column alias for the shipper's CompanyName name "Shipper". (Hint- You will need three tables.)

Then create a second query that returns the following columns: CustomerId, Company name from the customers table. OrderID from the orders table. Show all customers regardless of whether they have any orders. Sort the results by Order ID. (Hint - Requires Outer Join)