Ryerson University

• ITM 500

• -Lab Week 9 Solution --Using the Animal 2 Database write the SQL queries to satisfy the following. Submit this file with your SQL anwsers via D2L --1 List the zoo name, city and country for each zoo that holds at least 2 Lions SELECT ZooName, City, CountryLoc FROM Zoo WHERE ZooName IN (SELECT ZooName FROM Animal WHERE Species = 'Lion' GROUP BY ZooName HAVING count(*) >= 2) --2 List the details for Lion Experts whose salary is above average for their expertise SELECT * FROM Employee WHERE Species = 'Lion' and Salary > (SELECT AVG(Salary) FROM Employee WHERE Species = 'Lion') --3 List the details of all zoos that hold animals of an endangered species. --Only show each zoo's details once (Use a join approach) SELECT DISTINCT Z.* FROM Zoo Z INNER JOIN Animal A ON Z.ZooName = A.ZooName INNER JOIN Species S ON A.Species = S.Species WHERE Status = 'E'