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.
Cet exercice fait partie du cours
Improving Query Performance in SQL Server
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de 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);