Find out how much salary increase employee will receive based on city they work

First Develop a SQL query to find how much salary per year an employee earn and which city and country they work...

You can use Join technique

SELECT employee$\_$id$,$ salary, salary$*12,$ city $,$country

From employees JOIN departments

$......$

JOIN locations

$.....$

WHERE employee$\_$id$=195$

Build a code to determine which employee works for which city and report their increase based on the city they live

If employee is in Seattle and yearly salary is less than $90,000$ than they get $\%12$ increase of their salary but if it is more than $90,000$ then $14\%$ increase$($Calculate that and print on the screen with DMBS$\_$OUTPUT current salary, new increased salary, current yearly salary and increased total yearly salary

If employee is working in Toronto and yearly salary is less than $90,000$ than they get $\%15$ increase of their yearly salary but if it is more than $90,000$ then $17\%$ increase $($Calculate that and print on the screen with DMBS$\_$OUTPUT current salary, new increased salary, current yearly salary and increased total yearly salary

Sample output will be something like

Employee$\_$id first$\_$name last$\_$name City Cur$\_$salary Incresed salary Cur$\_$Yearly increased

$106$ James Furlan Toronto $5,0005,50060,00066,000$

BEGIN

SELECT

END;

Test the code with employee$\_$id $=201,$ Then test the code with employee$\_$id$=113$ and capture screen shot for both run