Complete in SQL Database with the following tables.

--Lab Week 3 Questions

--Using the Animal Database write the SQL queries to satisfy the following. Submit this file with your SQL answers via D2L

--1. List the details for all zoos that have -- the characters "Park" anywhere in their name

SELECT * FROM Zoo WHERE ZooName LIKE '%Park%'

--2 List the details for all employees whose name starts with --the character "J"

--3. List the details for all animals whose id's 4th digit is "1"

--4. List the details for all animals that were born after the end of September 2000

--5. List the details for all animals that born during September 2000

--6. Count the total number of lions born in 2000

--7. Count the number of different species held in the Whipsnade zoo

--8. Count the number of employees that are experts in a species

--9. What is the lowest estimate in wild for an endangered species

--10. What is the average salary for a lion expert

--11. Count the number of animals born in captivity ( have a value for the date of birth)

--12. Count the number of animals born in the wild

Animal Species Species: VARCHAR (15) NOT NULL has experts Animalld: CHAR (5) NOT NULL Status: CHAR (1) NULL EstolnWild: HUGE NULL Species: VARCHAR(15) NOT NULL (FK) ZooName: VARCHAR (20) NOT NULL (FK) Date Of Birth: DATE NULL Gender: CHAR (1) NULL employs | belongs o | + is held in Zoo Employee EmpNo: CHAR (4) NOT NULL EmpName: CHAR (10) NOT NULL Species: VARCHAR(15) NULL (FK) ZooName: VARCHAR (20) NOT NULL (FK) Salary: NUMBER (8,2) NOT NULL Gender. CHAR(1) NOT NULL ZooName: VARCHAR (20) NOT NULL City: VARCHAR(18) NOT NULL AnnualNoVisitors: INTEGER NULL CountryLoc: CHAR(12) NULL