A volcano located near a densely populated region is showing signs of a major eruption. Seismic activity, increased gas emissions, and tremors have raised the alarm for an imminent disaster. As part of the disaster management team, you are tasked with using data to assist in the evacuation and sheltering of citizens in at-risk neighborhoods. Your ability to analyze and interpret the data will play a crucial role in saving lives.

This exercise challenges you to use SQL to query and process information from multiple tables. You’ll help identify at-risk neighborhoods, allocate resources, and track evacuation progress efficiently.

Training Video:

---

Objectives

1. Understand the Threat:
   • Identify the volcano most likely to erupt and assess its potential impact.
2. Analyze the Risk:
   • Determine which neighborhoods fall within the destruction radius of the volcano.
   • Prioritize neighborhoods for evacuation based on population and proximity.
3. Plan Resource Allocation:
   • Calculate available shelter capacity and ensure it aligns with the needs of at-risk neighborhoods.
   • Analyze transportation resources to estimate evacuation feasibility.
4. Optimize Evacuation Efforts:
   • Match transportation resources to at-risk neighborhoods for efficient evacuation.
   • Allocate citizens to shelters while ensuring no shelter exceeds its capacity.
5. Track Progress:
   • Monitor the evacuation progress by calculating the total population evacuated and remaining at risk.
6. Evaluate Efficiency:
   • Assess the overall evacuation effort and identify potential gaps in resource planning.