• Left join the teams_spain table team_api_id column to the matches_spain table awayteam_id. This allows us to retrieve the away team's identity.
  • Select team_long_name from teams_spain as opponent and complete the CASE statement from Step 1.