Loading this exercise…

Task 3: Calculate Shelter Capacity

#3 · 3 of 9Free sample

Instructions

Task 3: Calculate Shelter Capacity

Retrieve the total `capacity` and `available_capacity` across all shelters.

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 →

All exercises in SQL Exercise: The Volcano Eruption Emergency

neighborhood_id

INTEGER

neighborhood_nameTEXT

populationINTEGER

distance_from_volcano_kmREAL

shelters3 cols

shelter_idINTEGER
capacityINTEGER
available_capacityINTEGER

transport3 cols

vehicle_idINTEGER
vehicle_typeTEXT
capacityINTEGER