Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
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).