As a Data Analyst, I need access to a list of all cities in the world, sorted by population from largest to smallest, to conduct global population analysis and demographic studies.
select country.Continent,
country.Name as 'County Name',
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
order by city.Population desc;
As a Data Analyst, I need access to a list of all cities in the world, sorted by population from largest to smallest, to conduct global population analysis and demographic studies.
select country.Continent, country.Name as 'County Name', 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 order by city.Population desc;