write the sql for the following:

1. list the species details of all animals in the Whipsnade zoo that are endangered. Show each species details only once.

2.list the details for all zoos in canada that have animals that are in an endangered species. Show each zoo's details only once.

3. list the species details for the animals that are held in that zoo that employs John. Only show each species details once.

Employee