Q12. (12 pts) Write SQL statements to insert the following 3 cities as well as your home city into the city table. If your home city is already listed, then add a different city you have visited. Leave the Population column of the last city empty. If your home country is not listed in the country table, you may also leave the Country column empty and add a comment in your SQL script file to explain this.

Then write a SQL query to list all the cities in the City table (show all the columns). For this question, you only need to submit the output of the last step.

	Name	Country	Population	Capital
1	Washington D.C.	United States	681170	Y
2	London	United Kingdom	8788000	Y
3	Iowa City	United States	74398	N

2

Q13 (6 pts). Add 100 to the population of all the cities in the United States. Write a SQL query to list all the affected cities and their new population values. For this question, you only need to submit the output of the last step.

Q14. (6 pts) Delete all non-capital cities from the City table. Write a SQL query to show the remaining cities (show all the columns). For this question, you only need to submit the output of the last step.