Exercise 4

#1

CREATE TABLE celebs (id INTEGER, name TEXT, age INTEGER);
INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Beiber', 21);
SELECT * FROM celebs;

My first 3 rows look like this...I'm not sure where the error is at...

According to the task: To view the row you just created, under the INSERT statement type

Am I missing something?

#2

No, you have something extra that this exercise isn't expecting. Remove the CREATE TABLE command.

#3

yeah, figured it out a little late...Thanks for the help though

#4

celebs (id INTEGER, name TEXT, age INTEGER);
INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Beiber', 21)
SELECT * FROM celebs;

This is mine but what is the wrong with this?

#5

You need to remove the entire command.