Let's analyze the first table, animal, which contains data about the animals in the zoo.
Select all the information from the animal table. Each animal has the following info:
id – The identifier of the animal in the database.species – The species of the animal.name – The name of that animal.city – The city where that animal was located before coming to the zoo.age – The age of the animal.arrived_date – When that animal arrived at the zoo. The default value for this column is the current date.picture – A link to the photo of the animal; if there is no photo, this field will store the string 'img/no-photo.jpg'.
