Loading this exercise…

Task 1: Counting The Last Survivors

#1 · 1 of 13Free sample

Instructions

Task 1: Counting The Last Survivors

Using the residents table, determine the total population of the Last City by summing the population values of all districts. Return a single column: 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 →

10 tables · 42 columns

residents3 cols

district_idINTEGER
district_nameTEXT
populationINTEGER

supplies4 cols

supply_idINTEGER
district_idINTEGER
supply_typeTEXT
days_remainingINTEGER

power_plants4 cols

plant_idINTEGER
plant_nameTEXT
statusTEXT
district_idINTEGER

medical_supplies5 cols

supply_idINTEGER
supply_nameTEXT
quantityINTEGER
unitTEXT
last_updatedTEXT

district_usage5 cols

district_idINTEGER
supply_idINTEGER
quantity_usedINTEGER
usage_dateTEXT
usage_timeTEXT

threat_reports5 cols

report_idINTEGER
district_idINTEGER
threat_typeTEXT
severityTEXT
timestampTEXT

security_logs6 cols

log_idINTEGER
district_idINTEGER
timestampTEXT
staff_nameTEXT
incidentTEXT
severityTEXT

shelters4 cols

shelter_idINTEGER
district_idINTEGER
capacityINTEGER
current_occupancyINTEGER

transport4 cols

vehicle_idINTEGER
vehicle_typeTEXT
capacityINTEGER
effective_capacityINTEGER

exhibits2 cols

exhibit_idINTEGER
exhibit_nameTEXT

Tables

10 tables