thommo1874 / GroupE

Apache License 2.0
0 stars 0 forks source link

Course Work 6. Top N populated countries in a region #20

Closed Susan-Osborne closed 3 years ago

Susan-Osborne commented 3 years ago

As an employee of the World Health Organisation, Population monitoring team a report is required of the top N populated countries in a region where N is provided by the user. Where "N" is a variable number

Connect to database Run the Query Report to be in CSV format include columns • The name of the region/country. • The total population of the region/country. • The total population of the region/country living in cities (including a %). • The total population of the region/country not living in cities (including a %).

A country report requires the following columns: Code. Name. Continent. Region. Population. Capital.