Loading this exercise…

Task 1: Identify The Most Dangerous Volcano

#1 · 1 of 9Free sample

Instructions

Task 1: Identify The Most Dangerous Volcano

Retrieve the `volcano_id`, `name`, and `predicted_destruction_radius_km` of the volcano with the highest probability of eruption.

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 →

volcano_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

Tables

4 tables