Task 2: Identify City Leaders With Dangerous Trends
#2 · 2 of 8Free sampleQuestion
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.
Tables4 tables · 17 columns
Tables
4 tables · 17 columnscities3 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)
Loading the practice editor and dataset…
Sign up to unlock
The reference answer is one click away.
Free account unlocks the reference answer, the explanation, and the GPT tutor on every exercise in the library.
- Reference answer + explanation revealed after each attempt
- GPT tutor for every problem
- Progress saved on the platform
- 1,598 graded exercises
- Free forever — no credit card