search

carolinemcsherry / SCAD

Software Engineering Methods Coursework Assessment
Apache License 2.0
1 stars 0 forks source link

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

Closed Antonia2206 closed 7 months ago

Antonia2206 commented 7 months ago

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 commented 7 months ago

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;