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.
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Initial query
SELECT TeamName,
TeamCode,
City
FROM ___ AS t -- Add table
WHERE ___ -- Operator to compare queries
(SELECT 1
FROM ___ AS e -- Add table
WHERE t.City = e.NearestPop);