Task 3: Calculate Shelter Capacity
#3 · 3 of 9Free sampleQuestion
Task 3: Calculate Shelter Capacity
Retrieve the total `
capacity` and `available_capacity` across all shelters.Tables4 tables · 16 columns
Tables
4 tables · 16 columnsvolcano_data6 cols
- volcano_idINTEGER
- nameTEXT
- predicted_destruction_radius_kmREAL
- eruption_probabilityREAL
- last_eruption_dateTEXT
- seismic_activity_scoreINTEGER
city_data4 cols
- neighborhood_idINTEGER
- neighborhood_nameTEXT
- populationINTEGER
- distance_from_volcano_kmREAL
shelters3 cols
- shelter_idINTEGER
- capacityINTEGER
- available_capacityINTEGER
transport3 cols
- vehicle_idINTEGER
- vehicle_typeTEXT
- capacityINTEGER
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