As with any job, players are given raises each year, write a query that calculates the increase each player received and calculate the % increase...

21.  As with any job, players are given raises each year, write a query that calculates the increase each player received and calculate the % increase that raise makes. You will only need to use the SALARIES table. You answer should include the columns below. Include the players full name and sort your results by playerid and year.

playerid             Player Name                                 yearid  Current              Prior                            Salary                 Salary

                                                                                                    Salary                 Salary                            Difference         Increase

aardsda01         David Allan ( David ) Aardsma   2008     $403,250.00             $387,500.00      $15,750.00        3.90%

aardsda01         David Allan ( David ) Aardsma   2009     $419,000.00             $403,250.00      $15,750.00        3.75%

aardsda01         David Allan ( David ) Aardsma   2010     $2,750,000.00             $419,000.00      $2,331,000.00  84.76%

aardsda01         David Allan ( David ) Aardsma   2011     $4,500,000.00             $2,750,000.00  $1,750,000.00  38.88%