Loading this exercise…

Task 2: Find Cities With Minimal Shelters

#2 · 2 of 10Free sample

Instructions

Task 2: Find Cities With Minimal Shelters

Retrieve city_id, city_name, and shelters_available for the 5 cities with the fewest shelters, ordered by shelters_available in ascending order.

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 →

j

Task 3: Track Alien Movements To Target Cities

All exercises in SQL Alien Invasion Challenge: Defend Earth

shelters_availableINTEGER

defense_levelINTEGER

resources4 cols

resource_idINTEGER
city_idINTEGER
resource_nameTEXT
quantityINTEGER

defenses4 cols

defense_idINTEGER
city_idINTEGER
defense_nameTEXT
power_levelINTEGER

alien_ship_movements5 cols

movement_idINTEGER
alien_idINTEGER
city_idINTEGER
departure_dateTEXT
arrival_dateTEXT

attacks6 cols

attack_idINTEGER
alien_idINTEGER
city_idINTEGER
attack_dateTEXT
damage_levelTEXT
casualtiesINTEGER