Download File for Final Exam Part $2-$ Northwind database.

Create queries to answer the following questions.

Name your queries: Query$1$ for question $1,$ Query$2$ for question $2$ and $...$

Save your file as Final$2$ and submit.

Select the Title, FirstName and LastName columns from the Employees table. Sort first by Title in ascending order and then by LastName in descending order.

Create a report showing the first and last name of all sales representatives whose title of courtesy is $"$Mr$.".$

Create a report showing the first and last name and the city of all employees who are from Seattle or Redmond.

Create a report showing the title of courtesy and the first and last name of all employees whose title of courtesy is $"$Mrs$."$ or $"$Ms$.".$

Create a report showing the title of courtesy and the first and last name of all employees whose title of courtesy begins with $"$M$".$

Create a report showing the first and last name of all employees excluding sales representatives.

Find the Average Unit Price of Products

Retrieve the number of employees in each city

Find the number of sales representatives in each city. Extra bonus: that contains at least $2$ sales representatives.

Order by the number of employees.

If the cost of freight is greater than or equal to $$500\mathrm{.}00,$ it will now be taxed by $10\%.$ Create a report that shows the order id$,$ freight cost, freight cost with this tax for all orders of $$500$ or more.