Loading this exercise…

Task 3: Determine the Vaccine Distribution Dates for Cities

#3 · 3 of 8Free sample

Instructions

Task 3: Determine the Vaccine Distribution Dates for Cities

Using the vaccine_distribution and cities tables, list each city and the corresponding date the vaccine was distributed. Join the tables on city_id and return the following columns: city_id, city_name, and vaccine_distribution_date (renamed as distribution_date).

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →

jNext →

Task 4: Find Cities with Overpopulated Camps

Tables

4 tables · 17 columns

cities3 cols

city_idINTEGER PRIMARY KEY
city_nameTEXT NOT NULL
populationINTEGER NOT NULL

infection_stats5 cols

record_idINTEGER PRIMARY KEY
city_idINTEGER NOT NULL
dateTEXT NOT NULL
new_infectionsINTEGER NOT NULL
FOREIGNKEY(city_id) REFERENCES cities(city_id)

vaccine_distribution3 cols

city_idINTEGER PRIMARY KEY
vaccine_distribution_dateTEXT NOT NULL
FOREIGNKEY(city_id) REFERENCES cities(city_id)

survivor_camps6 cols

camp_idINTEGER PRIMARY KEY
city_idINTEGER NOT NULL
camp_nameTEXT NOT NULL
capacityINTEGER NOT NULL
current_populationINTEGER NOT NULL
FOREIGNKEY(city_id) REFERENCES cities(city_id)

Tables

4 tables

cities3 cols

city_idINTEGER PRIMARY KEY
city_nameTEXT NOT NULL
populationINTEGER NOT NULL

infection_stats5 cols

record_idINTEGER PRIMARY KEY
city_idINTEGER NOT NULL
dateTEXT NOT NULL
new_infections

All exercises in Zombie Virus – Part 3: The Cure

INTEGER NOT NULL

FOREIGNKEY(city_id) REFERENCES cities(city_id)

vaccine_distribution3 cols

city_idINTEGER PRIMARY KEY
vaccine_distribution_dateTEXT NOT NULL
FOREIGNKEY(city_id) REFERENCES cities(city_id)

survivor_camps6 cols

camp_idINTEGER PRIMARY KEY
city_idINTEGER NOT NULL
camp_nameTEXT NOT NULL
capacityINTEGER NOT NULL
current_populationINTEGER NOT NULL
FOREIGNKEY(city_id) REFERENCES cities(city_id)