Exercise 4

[emerson_ang]

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?

[albionsrefuge]

Am I missing something?

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

[emerson_ang]

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

[blogrockstar73729]

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?

[borgette]

You need to remove the entire command.