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) SurfaceAreaFLOAT(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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!