Exercise 4

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?

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

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

1 Like

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?

You need to remove the entire command.