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 MS SQL Server

Introduction
2. Get to know the tables – VaccineAdministration
Summary

Instruction

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

Exercise

Select all information from the VaccineAdministration table.