Limit the rows with TOP
Your seismologist friend that is doing a study on earthquakes in South East Asia has asked you to subset a query that you provided her. She wants two additional queries for earthquakes recorded in Indonesia and Papua New Guinea. The first returning the ten shallowest earthquakes and the second the upper quartile of the strongest earthquakes.
Este ejercicio forma parte del curso
Improving Query Performance in SQL Server
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
SELECT ___ ___ -- Limit the number of rows to ten
Latitude,
Longitude,
Magnitude,
Depth,
NearestPop
FROM Earthquakes
WHERE Country = 'PG'
OR Country = 'ID'
___ ___ ___; -- Order results from shallowest to deepest