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—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.
  • ArrivedDate—when that animal arrived at the zoo.
  • Picture—a link to the photo of the animal; if there is no photo, this field will store the string N'img/no-photo.jpg'.