The databased used for these are employeeSample database

$1.$ Display the employeeid, last name and salary of employees

earning in the range of $$96,000$ to $$132,000$ inclusively.

$-$ Show the salary as a weekly salary instead of annual. There

is NOT exactly $52$ in a year, so dividing by $52$ is not good

enough. It is okay to assume it is NOT a leap year.

$-$ Sort the output by salary with top salaries first.

$2.$ Create a query to display the address of the various locations

where offices are located.

$-$ Add a parameter $($for the variable$)$ to the query such that the

user can enter all, or part of$,$ the city name and all locations

from the resultant cities will be shown.

$-$ Note: The user may include extra unnecessary spaces or use

incorrect capitalization. The query should still work for these

situations.

$3.$ For each employee in departments $20,50$ and $60,$ display the first

name, last name, department name, salary, and salary increased

by $4\%$ and expressed as a whole number.

$-$ Label the increased salary column "NewSalary".

$-$ Also add another column that subtracts the old salary from

the new salary and displays the difference. Label the column

"AnnualPayIncrease".

$-$ Sort the output first by department name, then by employee

lastname.

$4.$ Create a query that displays the city names, country codes and

state province names, but only for those cities that starts with $\text{'}$S$\text{'}$

and have at least $8$ characters in their name.

$-$ If a city does not have a province name assigned, then show

'Unknown Province' instead of null.

$5.$ Provide a list of ALL departments, what city they are located in$,$

and the first and last name of the current manager, if there is one.

Order by the department name alphabetically.

$6.$ You are to create a NEW table called Sales in the database for

storing sales information. The data Dictionary is as follows:

$7.$ Create insert statements for the sales table. The employee Steven

King sold $$3500,$ and for his entry add a note to say the target was

achieved.

$-$ Then show how to add an entry with the default value for

Neena Kochhar, who made a trial sale.