Challenge: Sort the Countries by Region and Capital
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 desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.44Awesome!
Completion rate improved to 2.44Challenge: Sort the Countries by Region and Capital
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 desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
single
Awesome!
Completion rate improved to 2.44Challenge: Sort the Countries by Region and Capital
Swipe to show menu
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 desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
