1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in SQL Server

Exercise

INNER JOIN

An insurance company that specializes in sports franchises has asked you to assess the geological hazards of cities hosting NBA teams. You believe you can get this information by querying the Teams and Earthquakes tables across the Earthquakes and NBA Season 2017-2018 databases respectively. Your initial query will use EXISTS to compare tables. The second query will use a more appropriate operator.

Instructions 1/3

undefined XP
    1
    2
    3
  • Add the table for the outer query.
  • Add the operator to compare the outer query with the sub-query.
  • Add the table for the sub-query.
  • Check the results. Only columns from the Teams table are returned.