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


The second table, employee, contains data about people working at the zoo.


Select all the data from the employee table. It contains the following columns:

  • id – A unique identifier for each employee.
  • first_name – The employee's first name.
  • middle_name – The employee's middle name; if they don't have a middle name, this field will be NULL.
  • last_name – The employee's last name.
  • age – The employee's age.