Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Population Sort | Sorting Retrieved Data
Introduction to SQL

Course Content

Introduction to SQL

Introduction to SQL

1. Retrieving Data
2. Sorting Retrieved Data
3. Filtering Data
4. Advanced Data Filtering
5. Aggregate Functions

Challenge: Population Sort

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 2. Chapter 2

Challenge: Population Sort

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 2. Chapter 2

Challenge: Population Sort

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

From the `country` table, retrieve the data from the `population` column, using a `SELECT` statement, and sort it in ascending order (default sort direction).
Here's a short example of the `country` table: