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.
Latihan ini adalah bagian dari kursus
Improving Query Performance in SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- 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);