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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostgreSQL INSERT, UPDATE, and DELETE Commands

Quiz
3. The employee table

Instruction

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

Exercise

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.