course content

Course Content

Introduction to SQL

Challenge: Find Countries, Their IDs, and Their PopulationsChallenge: Find Countries, Their IDs, and Their Populations


Write an SQL query to get id, name, and population columns from the country table (please retrieve these columns in this order).

Here's a short example of the country table:

1JapanAsiaEastern Asia377829Tokyo126714000
3MexicoNorth AmericaCentral America1958201Mexico City98881000
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 2. Chapter 9
toggle bottom row