SELECT what you need
Your friend is a seismologist, and she is doing a study on earthquakes in South East Asia. She asks you for a query that returns coordinate locations, strength, depth and nearest city of all earthquakes in Papua New Guinea and Indonesia.
All the information you need is in the Earthquakes
table, and your initial interrogation of the data tells you that the column for the country code is Country
and that the Codes for Papua New Guinea and Indonesia are PG
and ID
respectively.
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT ___ -- Select all rows and columns
FROM Earthquakes;