Correlated sub-query
Sub-queries are used to retrieve information from another table, or query, that is separate to the main query.
A friend is working on a project looking at earthquake hazards around the world. She requires a table that lists all countries, their continent and the average magnitude earthquake by country. This query will need to access data from the Nations and Earthquakes tables.
Deze oefening maakt deel uit van de cursus
Improving Query Performance in SQL Server
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT UNContinentRegion,
CountryName,
(SELECT ___(___) -- Add average magnitude
FROM Earthquakes e
-- Add country code reference
WHERE n.___ = e.Country) AS AverageMagnitude
FROM Nations n
ORDER BY UNContinentRegion DESC,
AverageMagnitude DESC;