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.
Este exercício faz parte do curso
Improving Query Performance in SQL Server
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- 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);