Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Find All Continents and Sort Them in Ascending Order | Sorting Retrieved Data
course content

Course Content

Introduction to SQL

Challenge: Find All Continents and Sort Them in Ascending OrderChallenge: Find All Continents and Sort Them in Ascending Order

Task

Write an SQL query to get unique continent values from the country table, and display the result in ascending order.

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 11
toggle bottom row
course content

Course Content

Introduction to SQL

Challenge: Find All Continents and Sort Them in Ascending OrderChallenge: Find All Continents and Sort Them in Ascending Order

Task

Write an SQL query to get unique continent values from the country table, and display the result in ascending order.

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 11
toggle bottom row
some-alt