Task 1: Identify The Most… · SQL Exercise: The Volcano…
Task 1: Identify The Most Dangerous Volcano
#1 · 1 of 9Free sample
Exercises (9)
Instructions
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…
Tables
4 tables · 16 columns
+
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
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