Needing help with questions 5-8 please !
X E P Q U Y Z AA BUS308-Quiz1 (1) A B Employee Last Name ID First Name D Date of Hire F Age H Salary Gender Date of Birth M N Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Comment Department Bonus R Days Absent Bonus T IF AND OR etc. IF AND OR etc. V IF AND OR etc. W IF AND OR IF AND OR etc. etc. B 1 4 B C 1 E D 0 D 3 4 E A 4 4 4 0 A E E A 2 4 4 D C 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 28.8 14.7 33.1 32.8 46.6 15.8 16.31 25.01 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.91 3 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Albouca 12 11631 Alexander 13 14548 Alvardo 14 14957 Anderson 15 12911 Anderson 16 14048 Ansari 17 13827 Atkinson 18 14765 Bacon Jr. 19 13250 Baldwin 20 14923 Balke 21 14675 Barbariol 22 10827 Barnhill 23 14584 Barr 24 10149 Barrett 25 11889 Bartkowski 26 14347 Beck 27 12005 Ben-Sachar 28 10069 Benson 29 12061 Berge 30 12833 Berglund 31 12037 Bergman 32 10940 Berry 33 13232 Blakeman 34 14038 Blose 35 11061 Bockman 36 13700 Bogdan HAN Employee Data 2 Anas 24-Jun-85 16-Oct-58 Kim 25-Mar-85 28-Jan-55 Pilar 26-Apr-89 5-Oct-50 Jeff 1-Feb-91 21-Dec-64 Kim 29-May-79 8-Apr-58 Sarah 15-Oct-89 22-Apr-70 Steve 12-Jan-92 28-May-64 Sean 6-Jul-00 16-Oct-62 Marion 21-Feb-05 26-Mar-76 Amy 11-Apr-92 1-Nov-70 Charlie 6-Jun-06 20-Jun-76 Zachary 27-Dec-87 26-Sep-51 Teresa 6-Apr-88 14-Jan-61 Dan 22-Jun-74 15-May-49 Amie 21-Apr-05 24-Nov-77 Wendy 21-Oct-04 15-Dec-76 Angela 16-Feb-96 18-Apr-64 Josh 26-Jul-77| 12-Oct-54 Adam 9-Jul-93 8-Apr-59 Holly 14-Mar-95) 30-Jan-70 Joanna 13-Jul-84 28-Feb-54 Bradley 20-Dec-98] 5-Feb-58 Ido 21-Sep-93 12-Jul-56 Max 22-Nov-99 2-Sep-75 Karen 1-Jun-97 27-Feb-65 Andreas 19-Mar-88 21-Oct-54 Ken 17-Mar-01 28-Jan-74 Jo 20-Sep-00 14-Jun-66 Synthia 1-Feb-91 21-Dec-64 Cleotilde 11-Sep-8727-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 61.49F 65.21 F 69.52 F 55.30 F 62.01 F 49.96 F 55.87 F 57.48 M 44.03 F 49.44 F 43.80 M 68.55 M 59.24 F 70.92 M 42.37 F 43.31 F 55.98 F 65.50 M 61.01 M 50.19 F 66.12 F. 62.18 M 63.75 F 44.60 M 55.12 F 65.48 M 46.19 M 53.82 F 55.30 F 63.88 F 68.40 F 55.72 F $ 91,000 $ 50,000 $ 31.000 $ 48,000 $ 47,000 $ 90,000 $ 100,000 $ 29,000 $ 53,000 $ 59,000 $ 48,000 $ 89,000 $ 55,000 $ 62,000 $ 100,000 $ 82,000 $ 92,000 $ 83,000 $ 66,000 $ 65,000 $ 33,000 $ 70,000 $ 77,000 $ 97,000 $ 45,000 $ 93,000 $ 58,000 $ 76,000 $ 48,000 $ 41,000 $ 43,000 $ 99,000 E D 30 16,309 30 19,0891 30 20.643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 25 12,691 10 11,3821 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 2015,767 30 19,195 25 17,579) 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 2015,456 30 19,186 15 10,803 20 14.991 30 20,569 30 19,966 2020,240 25 18,602 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 1,631 1,422 2349 2,471 3,144 1,499 1058 2,123 2,832 2,573 2,047 3067 2,640 2,731 1,628 2,153 2,670 1,489 2,079 2488 2915 3,212 1369 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 45091 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 41 E 4 4 D 2 3 41 A D 4 3 D E 5 Telululululula 19.90 4 Muchache 20.4 30.0 0 2 33.4) 22.5 29.9 0
