Challenge: Sort Capitals in Descending Order | Sorting Retrieved Data
Introduction to SQL

Course Content

Introduction to SQL

## Introduction to SQL

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

# Challenge: Sort Capitals in Descending Order

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.

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

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.

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 7

# Challenge: Sort Capitals in Descending Order

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.

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

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.

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 7

# Challenge: Sort Capitals in Descending Order

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.

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

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.

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?

Write an SQL query to retrieve all `capital` values from the `country` table, and display the results sorted in descending order.
Here's a short example of the `country` table: