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

Common Functions in PostgreSQL

Final Quiz
2. The person table

Instruction

Okay, now let's take a look at the person table and learn a bit about our members.

Exercise

Select all the information from the person table. For each member, we have the following columns:

  • id
  • branch_id – branch ID (for the branch this person belongs to; only one branch per person is possible at a time).
  • first_name
  • middle_name
  • last_name
  • registration
  • iq
  • weight in kilograms. 1 kilogram (kg) is roughly equal to 2.2 pounds (lbs).
  • height in centimeters. 1 inch is equal 2.54 centimeter (cm).