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


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

We will use a table named vaccine_administration 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 – A 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 vaccine_administration table.