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

GROUP BY Extensions in SQL

Introduction
2. Get to know the tables – vaccine_administration
Summary

Instruction

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).

Exercise

Select all information from the vaccine_administration table.