Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Dual-Sort Query | Sorting Retrieved Data
course content

Course Content

Introduction to SQL

Challenge: Dual-Sort QueryChallenge: Dual-Sort Query

Task

Retrieve two columns using the SELECT statement, specifically: region and capital. Sort the result first by region and then by capital.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 2. Chapter 4
toggle bottom row
course content

Course Content

Introduction to SQL

Challenge: Dual-Sort QueryChallenge: Dual-Sort Query

Task

Retrieve two columns using the SELECT statement, specifically: region and capital. Sort the result first by region and then by capital.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 2. Chapter 4
toggle bottom row
some-alt