Loading this exercise…

Task 3: Track Alien Movements To Target Cities

#3 · 3 of 10Free sample

Instructions

Task 3: Track Alien Movements To Target Cities

Retrieve alien_id, origin, city_name, departure_date, and arrival_date. Join alien_ship_movements with cities.

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 4: Analyze Resource Availability By City

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