BELOW IS PART OF THE TABLE, PLEASE WRITE OUT THE SQL QUERY FOR EACH QUESTION.

1. Table: sf_public_salaries

a) Find all employees with a job title that contains 'METROPOLITAN TRANSIT AUTHORITY' and output the employee's name along with the corresponding total pay with benefits.

b) Find job titles which had 0 hours of overtime

c) What job title had the highest totalpaybenefits

sf_public salaries basepay 100952.41 1121.28 overtimepay otherpay benefits totalpay totalpay totalpaybenefits year notes agency status 0 4254.88 34317.37 105207.29 139524.66 2014 NULL San Francisco PT 0 0 185.77 1121.28 1307.05 2012 NULL San Francisco NULL 138.18 2903.94 33625.27 95445.89 129071.16 2014 NULL San Francisco FT 0 0 9982.21 23757.5 33739.71 2014 NULL San Francisco PT 92403.77 23757.5 82115,61 666.79 1585.6 4390.15 1059.31 661.2 0 295.41 NULL 65061,57 52901.45 3307.79 21183.22 3841.15 29579 id employeename Jobtitle 120566 Teresa L Cavanaugh EMT/Paramedic/Firefighter 72002 Ray Torres Public Service Trainee 122662 Rizaldy T Tabada Deputy Sheriff 140133 Gregory B Bovo Firefighter 87502 Jason L Landivar EMT/Paramedic/Firefighter 71770 Fernando Barajas Public Svc Aide-Public Works 144682 George Fudge Transit Operator 148136 Jose F Granados Public Svc Alde-Public Works 72175 Linda Pizzorno Registered Nurse 110316 Sophia Wu Public Service Trainee 110441 Maria E Zuniga Transit Operator 57726 Sara Paredes Registered Nurse 135711 Adina M Diamond Registered Nurse 139629 Terry L Johnson Transit Operator 64401 Sherry Mahoney EMT/Paramedic/Firefighter 148022 Kari A Johnson Firefighter 114356 Joseph M Salazar Sergeant 3 104037 Annette Kess Transit Operator 71779 Ayala Mirande Special Nurse 143075 George L Abrams Jr Transit Operator 64411 Seaborn Chiles EMT/Paramedic/Firefighter 69659 Gwen Ferdinand Transit Operator 144573 Robert E Lee Jr E Transit Operator 72720 Andre Thomas Public Svc Alde-Public Works 60447 James Lockhart EMT/Paramedic/Firefighter 148014 Eric J Chen Public Service Trainee 109041 Paul J Ortiz Special Nurse 142145 Victor N Yeung Transit Operator 39463 Steven Stocker Sergeant 3 46861 Theresa Courtney Deputy Sheriff 83706 Donald V Ortiz Deputy Sheriff 688.71 5220.34 28933.91 88002.74 116936.65 2013 NULL San Francisco NULL 0 0 178.07 1585.6 1763.67 2012 NULL San Francisco NULL 12.11 2846.74 5461.57 8308.31 2014 NULL San Francisco PT 0 0 0 6.61 661.2 667.81 2014 NULL San Francisco PT 0 795.01 230.64 795.01 1025.66 2012 NULL San Francisco NULL 0 0 2.95 295.41 298.36 2013 NULL San Francisco NULL 0 114.54 0 114.54 114.54 2013 NULL San Francisco NULL 0 975 23477.4 66036.57 89513.97 2012 NULL San Francisco NULL 2286.95 19383.18 58496.19 77879.37 2014 NULL San Francisco PT 510.61 13384.77 25534.98 38919.75 2014 NULL San Francisco PT 0 2402.7 11785.19 31981.7 43766.89 2012 NULL San Francisco NULL 0 0 143.39 688.71 832.1 2014 NULL San Francisco PT 7510.15 40182.2 146448.22 186630.42 2014 NULL San Francisco FT 0 11808 7959.18 11808 19767.18 2013 NULL San Francisco NULL 44.11 388.96 1354.22 1743.18 2012 NULL San Francisco NULL 30.95 4742.85 8970.15 13713 2014 NULL San Francisco PT 1626.46 11871.64 31756.92 43628.56 2012 NULL San Francisco NULL 46.56 2806.53 4944.94 7751.47 2012 NULL San Francisco NULL 9.08 2847.85 5657.26 8505.11 2014 NULL San Francisco PT 0 2.44 13.84 158.29 172.13 2012 NULL San Francisco NULL 0 3801.37 17031.18 62643.37 79674.55 2012 NULL San Francisco NULL 0 35.66 8.35 835.79 844.14 2014 NULL San Francisco PT 0 243.6 451.01 2012.15 2463.16 2013 NULL San Francisco NULL 124770.09 14167.98 NULL 367.73 942.38 7316.62 1622.58 29579 551.46 4506.51 391.87 4390.16 1258.02 155.85 58842 800.13 1768.55 11889.93 0 0 6285.35 11889.93 18175.28 2014 NULL San Francisco PT 135977.79 1044 12934.3 36523.7 149956.09 186479.79 88374 3897.86 6778.32 34097.49 99050.18 133147.67 2012 NULL San Francisco NULL 2012 NULL San Francisco NULL 2013 NULL San Francisco NULL 2013 NULL San Francisco NULL 95126.53 57.21 6787.65 33016.42 101971.39 134987.81 Transit Operator 2056.09 0 0982.35 2056.09 3038.44 108749 Vivian A Showers 108321 Lenora Hamilton Transit Operator 2529.28 0 0 1464.59 2529.28 3993.87 2013 NULL San Francisco NULL