1- Calculate the annual salary of each employee. 2- Calculate the average ANNSAL of the employee who are in CA location. 3- Calculate the sum of ANNSAL of the employee who are in sales DEPT. OR Location 4 Find the name of employees who are in CA location, sales DEPT and Hired on 2/15/1997 5- Find the name of employees who are in sales DEPT. of WA location WK SAL ANNSAL RECORD LAST FIRST OFFICE IDNO HIRED DEPT NUMBER LOCATION 1 Birey Mary CA 20456 2/15/1997 Sales 9 Williams Todd CA 20648 2/15/1997 Admin 2 Darby Marge OR 21567 6/1/1999 Admin 12 Penney Jason CA 20846 2/20/1997 Sales 8 Lakoff Brian WA 23886 5/15/1999 Admin 14 Gibbons Dorothy OR 21668 6/15/1999 Sales 6 Casber William CA 20998 4/13/2000 Sales 5 Weeks David OR 21486 9/25/1999 Admin 13 Murphy Janelle WA 23112 6/15/1999 Sales 11 Sanderson David OR 21778 8/28/2000 Sales 3 Aiello. Anthony WA 23143 3/2/2000 Sales 4 Kearney Sharon CA 21980 8/24/2001 Sales 15 Smith Rebecca CA 207491 6/24/2001 Sales 17 Leary Gina CA 20998 7/15/2001 Sales 7 Gilchrest Cindy OR 21222 5/15/2000 Sales 10 Carey Barbara WA 23846 9/24/2001 Sales 16 Trent Robert OR 21980 6/30/2001 Sales 181 Arroz James WA 23999 8/30/2001 Sales $ 650.00 $ 650.00 $ 625.00 $ 565.00 $ 500.00 $ 495.00 5 490.00 $ 480.00 $ 480.00 $ 465.00 $ 460.00 $ 455.00 $ 455.00 $ 455.00 S 445.00 $ 445.00 $ 435.00 $ 430.00 Docu