Challenge: Find Countries, IDs, Populations, Regions, and Sort Them
Task
Swipe to start coding
Write an SQL query to get all id
, name
, and population
, region
columns from the country
table (please retrieve these columns in this order). Then, sort the results first by region
from Z to A and then by population
from lowest to highest.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 10