14 - Code Required - All the capital cities in a region organised by largest to smallest.

[Antonia2206]

As an Economic Development Officer, I need to analyse capital cities within a particular region, sorted by population from largest to smallest, to identify economic hubs, assess investment opportunities, and formulate development strategies aimed at promoting regional prosperity and growth

[Antonia2206]

select
A. Name as cityname,
B. Name as countryname,
B. Region,
A. Population
from city A
left join country B on A. CountryCode = B. Code;