Loading this exercise…

Task 2: Identify City Leaders With Dangerous Trends

#2 · 2 of 8Free sample

Instructions

Task 2: Identify City Leaders With Dangerous Trends

Using the survivor_camps table, determine the total population in all survivor camps across all cities. Sum the current_population column and return a single column named total_population.

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 3: Determine the Vaccine Distribution Dates for Cities

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)