1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in SQL Server

Exercise

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.

Instructions 1/2

undefined XP
    1
    2
  • SELECT all rows and columns from the Earthquakes table.
  • Look at the results of the query to determine which other columns to select.