Loading this exercise…

Task 2: List All At-Risk Neighborhoods

#2 · 2 of 9Free sample

Instructions

Task 2: List All At-Risk Neighborhoods

Retrieve the neighborhood_name, population, and distance_from_volcano_km for all neighborhoods within the volcano's destruction radius.

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