Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Find Countries, IDs, Populations, Regions, and Sort Them | 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: Find Countries, IDs, Populations, Regions, and Sort Them

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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 10

# Challenge: Find Countries, IDs, Populations, Regions, and Sort Them

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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 10

# Challenge: Find Countries, IDs, Populations, Regions, and Sort Them

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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?

Task

Write an SQL query to get all `id`, `name`, and `population`, `region` columns from the `country` table (please retrieve these columns in this order). Then, sort the results first by `region` from Z to A and then by `population` from lowest to highest.

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

Section 2. Chapter 10
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?