Write in sql

Tables

Question

Format

00 city ID INT (11) Name CHAR(35) CountryCode CHAR(3) District CHAR(20) Population INT(11) Indexes countrylanguage CountryCode CHAR(3) Language CHAR(30) Isofficial ENUMCT',F) Percentage AOAT(4,1) Indexes country Code CHAR(3) Name CHAR(52) Continent ENUM...) Region CHAR (26) SurfaceArea FLOAT(10,2) IndepYear SMALLINT (6) Population INT(11) LifeExpectancy FLOAT(3,1) GNP FLOAT(10,2) GNPOld ALOAT(10,2) LocalName CHAR(45) GovernmentForm CHAR(45) Headofstate CHAR(60) Capital INT(11) Code2 CHAR(2) Indexes For all countries whose government form is a 'Federal Republic', and whose official language is either 'English' or 'German', add 100,000 to their population, set their GNPOld to be equal to their current GNP, then increase their current GNP by 10,000 Be careful! The order of your query matters! 1 UPDATE country, 2 countrylanguage 3 SET 4 5 WHERE 6