Sovi.AI - AI Math Tutor

Scan to solve math questions

QUESTION IMAGE

jump to level 1 country tld\tiso_code2\tcapital\tname .sd\tsd\tkhartoum…

Question

jump to level 1
country
tld\tiso_code2\tcapital\tname
.sd\tsd\tkhartoum\tsudan
.de\tde\tberlin\tgermany
.ua\tua\tkyiv\tukraine
complete the statement that creates the table.
create table country (
tld char(3),
iso_code2 char(2),
capital varchar(15),
name varchar(15),
/ your code goes here /
);

Explanation:

Step1: Identify primary key

The table has a primary key marker (●) on the tld column, so we need to define it as the primary key.

Step2: Add primary key constraint

Insert PRIMARY KEY (tld) in the placeholder to specify the primary key.

Answer:

PRIMARY KEY (tld)