1 - Create database
2 - People table
3 - Countries table
4 - StateProvinces table
5 - Cities
6-Additional Note
Scenario 1- Display Country records
FREE PREVIEWScenario 2- Last edited records
Scenario 3- Average Population
Scenario 4- States in US
Scenario 5- Listing States
Scenario 6- Population range
Scenario 7- Cities in California
Scenario 8- Counting States outside US
Scenario 9- Listing Cities in US
Scenario 10- State with largest population
Scenario 11- Find person who edited records
Scenario 12- Find person who edited Cities data
Scenario 13- States with no City details
Scenario 14- Counting cities in Americas
FREE PREVIEWScenario 16- Missing Population count
Scenario 15- Find person who edited all data
Scenario 17- States and Cities
Scenario 18- States and their population
Scenario 19- Countries and their population
Scenario 20- Latest Recorded Population
Scenario 21- Finding email address
Scenario 22- Cities in low populated state
Scenario 23- State with second lowest population
Scenario 24- State with fifth lowest population
Scenario 25- Cities having Latest Recorded Population
Scenario 26- Countries within a Continent
Scenario 27- Countries and their States
Scenario 28- Counting Cities in each State
Scenario 29- Countries added each year
Scenario 30- Find person in specific designation
Thank You!
