--Lab Week 2 --Using the Animal Database write the SQL queries to satisfy the following. Submit this file with your SQL anwsers via D2L --The answer to the first question is provided --Q1. List the id , zoo name and species for all animals SELECT AnimalId, ZooName, Species FROM Animal --Q2. List the id ,zoo name and species for all male gender animals --Q3. List the zoo name, city and annual visitors for zoos where annual visitors number at least 30,000 but more than 6,000,000 --04 List the details for all employees that are Lion experts and earn over $40,000 --05. List the details for all employees whose expertise is in either the Lion or Tiger species --06. List the details for all employees employed by the Riverdale zoo whose expertise is in either the Lion or Tiger species --07. List details for all animals except those whose species is either Lion or Tiger --08. List the details for all Lion animals. Sequence the output by gender within zoo i.e. zoo is the major key --09. List the details for all endangered (status = E) with an estimate of less than 10,000 left in the wild. highest to lowest estimate. Sequence the output from the --010. List the details for all animals whose species is either Lion or Panda, and whose gender is male. -- Sequence the output by zoo name within species