Loading…
Retrieve alien_id, the alien's home_planet (from the aliens table), city_name, departure_date, and arrival_date for every ship movement. Join alien_ship_movements with cities (on city_id) and with aliens (on alien_id), and order the results by arrival_date ascending.
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.