Sovi.AI - AI Math Tutor

Scan to solve math questions

QUESTION IMAGE

refer to the create table statement: create table country ( iso_code2 c…

Question

refer to the create table statement:
create table country (
iso_code2 char(2),
population int,
name varchar(50),
primary key(iso_code2)
);
complete the statement to insert a row with iso_code2 sy, population 16906283,
and name syria. 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 table columns are iso_code2, population, name.

Step2: Match values to columns

Values: 'SY' (iso_code2), 16906283 (population), 'Syria' (name).

Step3: Format VALUES clause

Start with VALUES, enclose values in parentheses.

Answer:

VALUES ('SY', 16906283, 'Syria')