Question

jump to level 1
country
iso_code2\tiso_code3\tname\tpop_density
iq\tirq\tiraq\t229.3
gh\tgha\tghana\t338.8
km\tcom\tcomoros\t1158.4
complete the statement that creates the table.
create table country (
iso_code2 char(2),
iso_code3 char(3),
name varchar(15),
pop_density decimal(7, 2),
/ your code goes here /
);

Explanation:

Step1: Identify primary key

The table shows iso_code2 marked as the primary key (blue dot).

Step2: Add primary key constraint

Include PRIMARY KEY (iso_code2) at the end of column definitions.

Answer:

PRIMARY KEY (iso_code2)