My code is not runnig

Hello everyone, I am studying the data scientist carrer path and I trying to run this code, however, the query window after I completed the code of my first project, it does not run and the window is empty. Here is the code.

I will appreciate any help:

CREATE TABLE friends(

id INTEGER,

name TEXT,

birthday DATE

);

INSERT INTO friends (id, name, birthday)

VALUES (1, “Ororo Munroe”, “1940-05-30”)

SELECT * FROM friends;

INSERT INTO (id, name, birthday)

VALUES (2, “Charle Dentt”, “1942-06-20”);

INSERT INTO (id, name, birthday)

VALUES (3, “Magnus Campus”, “1941-03-15”);

UPDATE friends

SET name = ‘Storm’

WHERE id = 1;

ALTER TABLE friends

ADD COLUMN email TEXT;

UPDATE friends

SET email = ‘[email protected]

WHERE id = 1;

UPDATE friends

SET email = ‘[email protected]

WHERE id = 2;

UPDATE friends

SET email = ‘[email protected]

WHERE id = 3;

DELETE FROM friends

WHERE id = 1;

SELECT * FROM friends;

Hello @course9235619223 ,

Welcome to the forums!

Can you please include the link to the lesson?

Hi thank you. This is the link.

https://www.codecademy.com/paths/data-science/tracks/dsf-learn-sql/modules/dsinf-learn-sql-manipulation/projects/learn_sql_create_table

kind regards

Your first INSERT statement is missing a semi-colon at the end.

For troubleshooting, I started by running each statement at a time. It makes it easier to narrow down the problem. I think the rest of your statements look good :+1:

2 Likes