It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Quiz
2. The animal table

Instruction

Let's analyze the first table, animal, which contains data about the animals in the zoo.

Exercise

Select all the information from the animal table. Each animal has the following info:

  • id – a number that identifies each animal in the database.
  • species – the species of the animal.
  • name – the name of that animal.
  • city – the city where that animal came from.
  • age – the age of the animal.
  • arrived_date – when that animal arrived at the zoo. The default value for this column is 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'.