As an Urban Planner, I need to analyse cities within a particular region, sorted by population from largest to smallest, to make informed decisions regarding infrastructure development, resource allocation, and city planning initiatives.
select
city.Name as 'City Name',
city.District,
city.Population as 'Population descending'
from city
JOIN country ON country.Code = city.CountryCode # joining the table country to countrylanguage
where country.Region = 'Caribbean' #This will be user defind var
order by city.Population desc;
As an Urban Planner, I need to analyse cities within a particular region, sorted by population from largest to smallest, to make informed decisions regarding infrastructure development, resource allocation, and city planning initiatives.
select city.Name as 'City Name', city.District, city.Population as 'Population descending' from city JOIN country ON country.Code = city.CountryCode # joining the table country to countrylanguage where country.Region = 'Caribbean' #This will be user defind var order by city.Population desc;