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.
Bu egzersiz
Improving Query Performance in SQL Server
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- 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);