Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Challenge: Sort the Countries by Region and Capital | Sorting Retrieved Data
Introduction to SQL

Swipe to show menu

book
Challenge: Sort the Countries by Region and Capital

Task

Swipe to start coding

Write an SQL query to retrieve three columns from the country table using the SELECT statement, namely: name, region, and capital (please retrieve these columns in this order). Sort the result by two of them - first by region in descending order, then by capital, also in descending order.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 6
We're sorry to hear that something went wrong. What happened?

Ask AI

expand
ChatGPT

Ask anything or try one of the suggested questions to begin our chat

book
Challenge: Sort the Countries by Region and Capital

Task

Swipe to start coding

Write an SQL query to retrieve three columns from the country table using the SELECT statement, namely: name, region, and capital (please retrieve these columns in this order). Sort the result by two of them - first by region in descending order, then by capital, also in descending order.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 6
Switch to desktopSwitch 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?
some-alt