Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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.