--Lab Week 4 --Using the Animal Database write the SQL queries to satisfy the following. Submit this file with your SQL anwers via D2L

1 List the total expert salary amount for each species. Sequence the output, highest to lowest total

2 List the average employee salary by zoo but only show the situations where the average is at least 65000

3 List the zooname for zoos than have more than 2 pandas

4 List the species details of all animals in the Whipsnade zoo that are endangered. Show each species's details only once

5 List the species that has more than 2 experts

6 List the details for all zoos in Canada that have animals that are in an endangered species. Show each zoo's details only once.

7. List the details for all lion expert employees who work at zoos that have lions. Only show an employee's details once.

8. List the details for all expert employees who work at zoos --that have animals of their species expertise. Only show an employee's details once. -- Sequence the output by employee name within species within zoo name

9. List the species details for the animals that are held in the zoo that employs John. Only show each species'details once.

10 i) Add a new Employee to the database -

ii) Change the expertise and the increase the salary by 10% (use an expression).

iii) Delete the Employee added above