Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Get to know the tables – VaccineAdministration


Let’s get to know the tables we’ll be working with.

We will use a table named VaccineAdministration in our examples. It describes vaccination efficacy in various test patients. The following columns are available:

  • Id – A unique identifier for each record/row in the table.
  • Location – T patient’s location, either Norway or Argentina.
  • Gender – Denoted as either Male or Female.
  • Risk – The patient’s risk of contracting a disease: Low, Medium, or High.
  • Age – The patient’s age in years.
  • Efficacy – An integer value ranging from 1 (poor vaccination efficacy) to 3 (excellent efficacy).


Select all information from the VaccineAdministration table.