Using python and SQLite, connect to the database called "world.db$".$ Using SQL queries in

python, answer the following questions $($make appropriate comments for each step$)$:

a$.$ Input the data into table 'city':

ID for city City Name Code for country City population

$5000$ King's Landing WTO $5,000,000,000$

After you input the data, print out just this record from table 'city' to verify it is there.

Take a screenshot and put in the word file

b$.$ Using python, print out the country Name, Continent, Region and the country Population

of all the countries, whose country population is larger than $1,000,000,000.$

Question:

Since we already updated the data in step $\text{'}$a$\text{'}$ for city 'King's Landing' in country 'Westero'

$($country code WTO$),$ whose population is $5$ billion $($larger than $1$ billion$),$ did you find

country 'Westero' in the result from step b$?$ Why or why not? Take a screenshot and put

in the word file

c$.$ Print out all the fields for the cities in the U$.$S$.$ whose city population is larger than

$1,000,000.$ Use queries to calculate how many cities in the result? What is the average

population for them? Take a screenshot and put in the word file