Q12 . (12 pts) Write SQL statements to insert the following 3 cities as well as
ID: 3596800 • Letter: Q
Question
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.
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
Explanation / Answer
1.
insert into city(Name, Country, Population, Capital)
values('Delhi', 'India', 197383, 'Y');
select * from city;
2.
UPDATE city
SET Population = Population + 100
WHERE Country='United States';
3.
delete from city
where Capital='N';
select * from city;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.