Exercise

Get team names with correlated subqueries

Let's solve the same problem using correlated subqueries -- How do you get both the home and away team names into one final query result?

This can easily be performed using correlated subqueries. But how might that impact the performance of your query? Complete the following steps and let's find out!

Please note that your query will run more slowly than the previous exercise!

Instructions 1/2

undefined XP
    1
    2
  • Using a correlated subquery in the SELECT statement, match the team_api_id column from team to the hometeam_id from match.