Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Basic INSERT statement

Add a row

Report a typo

Select all INSERT INTO queries that will insert correct rows into the table waiters that was created with the following SQL query:

CREATE TABLE waiters (
 name VARCHAR(30), 
 surname VARCHAR(30), 
 hourly_wage INT, 
 age INT
);

Select one or more options from the list

INSERT INTO waiters (name, hourly_wage, age) VALUES ('Ann', 16, 20)

INSERT INTO waiters (name, surname, age) VALUES ('Tom', 'Black', 20)

INSERT INTO waiters VALUES ('Carl', 'Smith', 15, 17)

INSERT INTO waiters (name, surname, age) VALUES ('John', 'Rose', 16.5)

___

Create a free account to access the full topic