Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. The animal table


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'.