Question: 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 FLOAT(10,2) LocalName CHAR(45)



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 FLOAT(10,2) LocalName CHAR(45) GovernmentForm CHAR(45) HeadOfState CHAR(60) Capital INT(11) Code2 CHAR(2) Indexes Add a column named "National Sport" of type varchar to the country table. Hint: Column name contains a space so you need to use backticks. ( Full Screen query.sql # New 1 ALTER TABLE country 2 3 ADD (National Sport) VARCHAR (50) NOT NULL; SELECT DISTINCT(`National Sport") FROM country; POST HOOK QUERY RESULTS O SQL POST HOOK ERROR OUTPUTO query returned no results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
