Task 2: List All At-Risk Neighborhoods
#2 · 2 of 9Free sampleQuestion
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.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