Question

1 Approved Answer

Posted on Jun 03, 2024

Qs5: List the detail of animals that are in captivity in any zoo whose mother Is currently in the Toronto zoo. Qs6: List the names,

Qs5: List the detail of animals that are in captivity in any zoo whose mother Is currently in the Toronto zoo.

Qs6: List the names, gender and salaries of all male employees that are the worlds

best expert for a threatened species (status = T)

Employee Gare Condensedy Noble Species Colorare Conde Specie www15 No Spece Zoom wah20 N PETER We will Zoo Conan Concert Type Nulle www Oy No Avvisitors Courtytex chata Animal Columns Condensede de + A wa Ne Dooms Gende Muthaha 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Animaild Species ZooName DateOfButh Gender Mother Animallid Father Animalia 00001 Tiger Toronto Cty Zoo 2003-09-2 F 00013 00005 00002 Tiger Toronto Cty Zoo NULL M NULL NULL 00003 Lion Riverdale 2016-04-05 M 00014 00015 00004 Rhino Whipsnade Park 2006-09-09 M 00012 00006 00005 Tiger Whipsnade Park 1998-04-04 M NULL NULL 00006 Rhino Toronto City Zoo NULL M NULL NULL 00007 Bear Boston City 200 2000-07-07 M 00034 00018 00008 Monkey Toronto Cty Zoo 1999-09-09 F 00035 00036 00009 Monkey Whipsnade Park 1999-03-03 F 00035 00030 00010 Gorilla Whipsnade Park 2006-04-04 F NULL NULL 00011 Panda Riverdale NULL F NULL NULL 00012 Rhino Whipsnade Park NULL F NULL NULL 00013 Tiger Whipsnade Park 2000-03-08 F NULL NULL 00014 Lion Whipsnade Park 2006-09-15 F 00023 00041 00015 Lion Whipsnade Park 2017-09-22 M 00014 00042 00016 Lion Whipsnade Park 2001-09-09 F 00031 00042 00017 Gorila Riverdale 2006-09-06 M NULL NULL 00018 Bear Whipsnade Park NULL M NULL NULL 00019 Manatee Whipsnade Park NULL M NULL NULL 00020 Aligator Riverdale 2003-01-01 F NULL NULL 00021 Panda Aligator Park 2005-01-01 F 00011 00024 00022 Lion Aligator Park 2006-01-01 M NULL 00041 00023 Lion Toronto City Zoo 2005-12-13 F NULL 00041 00024 Panda Pandavile NULL M NULL NULL 00025 Panda Red Star NULL F NULL NULL 00026 Panda Red Star 2005-12-12 M NULL NULL 00027 Panda Red Star 2005-10-12 M NULL 00025 00028 Rhino Bowmanville NULL M NULL NULL 00029 Rhino Boston City Zoo NULL M NULL NULL 00030 Rhino Red Star NULL M NULL NULL 00031 Lion Red Star 2005-11-12 F NULL NULL 00032 Lion Big Cat 2016-12-09 M NULL 00041 00033 Big Cat 2016-12-25 F NULL NULL 00034 Bear Big Cat F NULL NULL 00035 Monkey Whipsnade Park NULL F NULL NULL 00036 Monkey Whipsnade Park NULL M NULL NULL 00037 Gorilla Red Star 2016-10-21 M 00010 00017 00038 Gona Whipsnade Park 2015-11-10 M 00010 00017 00039 Monkey Red Star 2016-03-17 F 00035 00036 00040 Lion Big Cat NULL F NULL NULL 00041 Lion Big Cat NULL M NULL NULL 00042 Lion NULL M NULL NULL Lion NULL 39 40 41 42 Big Cat Lion Emo EmpName Species ZooName Salary Gender 1 3001 Abrams Lion Aligator Park 3500000 M 2 3002 Ray NULL Alligator Park 11000000 M 3 3003 John Tiger Riverdale 7500000 M 4 3004 Mary Riverdale 11000000 M 5 3005 Peter NULL Riverdale 8000000 M 6 3000 Hennetta Tiger Whipsnade Part 9000000F 7 3007 Witam Tiger Riverdale 3500000 M 8 3000 Aligator Whipsnade Park 40000 00 F 9 3009 Jack Aligator Whipsnade Park 3000000 M 10 3010 Deborah Lion Whipsnade Park 10000000 F 11 3011 Mangold NULL Whipsnade Park 4500000 M 12 3012 Jean Bear Riverdale 8000000 F 13 3013 May Rhino Boston City Zoo 75000.00 F 14 3014 Norma Rhino Bowmanville 6500000 F 15 3015 Fred Bear Toronto Cly Zoo 4500000 M 16 3016 George Lion Riverdale 6800000 M 12 3017 John NULL Aligator Park 3333000 M 18 3018 Paul NULL Big Cat 5500000 M 19 3019 Aloe Panda Panduite 6700000 F 20 3020 Red Bear Red Star 12000000 M [Species! Species Status Est Nonwid World BestEmpNo 1 Aligator E 4400 3008 2 Bear E 11000 3015 3 Gorica E 550 NULL 4 Lion T 27500 3004 5 Manatee T 330 NULL . Monkeys 165000 NULL 2 Panda s 38500 3019 8 Parrot S 30000000000 NULL 9 Rhino E 54 3014 10 Tiger T 54 3007 VA [Zoo) ZooName Oy AnnaNoVistors Country. 1 Aligator Park Jackson 21000 USA 2 Big Cat Kingston 35 Canada 3 Boston GlyZoo Boston 300000 USA Bowmanville Toronto 100 Canada 5 Panda Being 4000000 Chwa 6 Red Star Shanghai 5000000 China 7 Riverdale Toronto 20000 Canada Toronto Cly Zoo Toronto 15000 Canada 9 Whipurade Park London 30000 UK Employee Gare Condensedy Noble Species Colorare Conde Specie www15 No Spece Zoom wah20 N PETER We will Zoo Conan Concert Type Nulle www Oy No Avvisitors Courtytex chata Animal Columns Condensede de + A wa Ne Dooms Gende Muthaha 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Animaild Species ZooName DateOfButh Gender Mother Animallid Father Animalia 00001 Tiger Toronto Cty Zoo 2003-09-2 F 00013 00005 00002 Tiger Toronto Cty Zoo NULL M NULL NULL 00003 Lion Riverdale 2016-04-05 M 00014 00015 00004 Rhino Whipsnade Park 2006-09-09 M 00012 00006 00005 Tiger Whipsnade Park 1998-04-04 M NULL NULL 00006 Rhino Toronto City Zoo NULL M NULL NULL 00007 Bear Boston City 200 2000-07-07 M 00034 00018 00008 Monkey Toronto Cty Zoo 1999-09-09 F 00035 00036 00009 Monkey Whipsnade Park 1999-03-03 F 00035 00030 00010 Gorilla Whipsnade Park 2006-04-04 F NULL NULL 00011 Panda Riverdale NULL F NULL NULL 00012 Rhino Whipsnade Park NULL F NULL NULL 00013 Tiger Whipsnade Park 2000-03-08 F NULL NULL 00014 Lion Whipsnade Park 2006-09-15 F 00023 00041 00015 Lion Whipsnade Park 2017-09-22 M 00014 00042 00016 Lion Whipsnade Park 2001-09-09 F 00031 00042 00017 Gorila Riverdale 2006-09-06 M NULL NULL 00018 Bear Whipsnade Park NULL M NULL NULL 00019 Manatee Whipsnade Park NULL M NULL NULL 00020 Aligator Riverdale 2003-01-01 F NULL NULL 00021 Panda Aligator Park 2005-01-01 F 00011 00024 00022 Lion Aligator Park 2006-01-01 M NULL 00041 00023 Lion Toronto City Zoo 2005-12-13 F NULL 00041 00024 Panda Pandavile NULL M NULL NULL 00025 Panda Red Star NULL F NULL NULL 00026 Panda Red Star 2005-12-12 M NULL NULL 00027 Panda Red Star 2005-10-12 M NULL 00025 00028 Rhino Bowmanville NULL M NULL NULL 00029 Rhino Boston City Zoo NULL M NULL NULL 00030 Rhino Red Star NULL M NULL NULL 00031 Lion Red Star 2005-11-12 F NULL NULL 00032 Lion Big Cat 2016-12-09 M NULL 00041 00033 Big Cat 2016-12-25 F NULL NULL 00034 Bear Big Cat F NULL NULL 00035 Monkey Whipsnade Park NULL F NULL NULL 00036 Monkey Whipsnade Park NULL M NULL NULL 00037 Gorilla Red Star 2016-10-21 M 00010 00017 00038 Gona Whipsnade Park 2015-11-10 M 00010 00017 00039 Monkey Red Star 2016-03-17 F 00035 00036 00040 Lion Big Cat NULL F NULL NULL 00041 Lion Big Cat NULL M NULL NULL 00042 Lion NULL M NULL NULL Lion NULL 39 40 41 42 Big Cat Lion Emo EmpName Species ZooName Salary Gender 1 3001 Abrams Lion Aligator Park 3500000 M 2 3002 Ray NULL Alligator Park 11000000 M 3 3003 John Tiger Riverdale 7500000 M 4 3004 Mary Riverdale 11000000 M 5 3005 Peter NULL Riverdale 8000000 M 6 3000 Hennetta Tiger Whipsnade Part 9000000F 7 3007 Witam Tiger Riverdale 3500000 M 8 3000 Aligator Whipsnade Park 40000 00 F 9 3009 Jack Aligator Whipsnade Park 3000000 M 10 3010 Deborah Lion Whipsnade Park 10000000 F 11 3011 Mangold NULL Whipsnade Park 4500000 M 12 3012 Jean Bear Riverdale 8000000 F 13 3013 May Rhino Boston City Zoo 75000.00 F 14 3014 Norma Rhino Bowmanville 6500000 F 15 3015 Fred Bear Toronto Cly Zoo 4500000 M 16 3016 George Lion Riverdale 6800000 M 12 3017 John NULL Aligator Park 3333000 M 18 3018 Paul NULL Big Cat 5500000 M 19 3019 Aloe Panda Panduite 6700000 F 20 3020 Red Bear Red Star 12000000 M [Species! Species Status Est Nonwid World BestEmpNo 1 Aligator E 4400 3008 2 Bear E 11000 3015 3 Gorica E 550 NULL 4 Lion T 27500 3004 5 Manatee T 330 NULL . Monkeys 165000 NULL 2 Panda s 38500 3019 8 Parrot S 30000000000 NULL 9 Rhino E 54 3014 10 Tiger T 54 3007 VA [Zoo) ZooName Oy AnnaNoVistors Country. 1 Aligator Park Jackson 21000 USA 2 Big Cat Kingston 35 Canada 3 Boston GlyZoo Boston 300000 USA Bowmanville Toronto 100 Canada 5 Panda Being 4000000 Chwa 6 Red Star Shanghai 5000000 China 7 Riverdale Toronto 20000 Canada Toronto Cly Zoo Toronto 15000 Canada 9 Whipurade Park London 30000 UK