As an employee of the World Health Organisation, Population monitoring team a report is required of all the cities in a region organised by largest population to smallest.
Connect to database
Run the Query
Report to be in CSV format
A city report requires the following columns:
Name.
Country.
District.
Population.
For the population reports, the following information is requested:
The name of the regions.
The total population of the regions.
The total population of the regions living in cities (including a %).
The total population of the regions not living in cities (including a %).
As an employee of the World Health Organisation, Population monitoring team a report is required of all the cities in a region organised by largest population to smallest.
Connect to database Run the Query Report to be in CSV format
A city report requires the following columns: Name. Country. District. Population.
For the population reports, the following information is requested:
The name of the regions. The total population of the regions. The total population of the regions living in cities (including a %). The total population of the regions not living in cities (including a %).