Question

jump to level 1
refer to the create table statement:
create table country (
iso_code2 char(2),
name varchar(50),
population int,
primary key(iso_code2)
);
complete the statement to insert a row with iso_code2 ao, name angola, and population 30809762. your answer should begin with the keyword values followed by three column values in parentheses.
insert into country
/ your code here / ;

Explanation:

Step1: Identify column order

The country table columns are iso_code2, name, population.

Step2: Match values to columns

iso_code2='AO' (CHAR), name='Angola' (VARCHAR), population=30809762 (INT).

Step3: Format VALUES clause

Enclose values in parentheses, start with VALUES.

Answer:

VALUES ('AO', 'Angola', 30809762)