A wrong report led to wrong entries in the world database.
We need to add 1% to the population of all cities in Europe.
Which of the following update statements can we use?
A.
UPDATE (SELECT Code FROM Country WHERE Continent = ‘Europe’) AS co. City AS ci
SET population = ROUND(population + (population*0.01)
WHERE co.Code = ci.CountryCode
B.
UPDATE (SELECT ci.ID,ci.Population FROM City AS ci. Country AS co WHERE ci.CountryCode = co.Code AND Continent = ‘Europe’) AS p
SET c.population = ROUND(population +(population*0.01)
C.
UPDATE (SELECT ID,Population FROM City) as ci. Country AS co
SET ci.population = ROUND(population + (population*0.01)
WHERE ci.CountryCode = co.Code