Creating a table in SQL - Query not running

Hello, I’m completing the data scientist: Data analytics specialist course, and am on the SQL project whereby I have to create a table.

Learn SQL > Manipulation > Create a Table.

I have put in the correct code, checked it against the sample solution, yet when I press save, it for some reason doesn’t show any results on the right hand side (Doesn’t run anything).

It says if this is the case that the code is wrong, but I’ve very diligently checked it against the sample solution, so am really unsure what the issue is. I don’t want to proceed until this is checked, can you look into this please? I will also include my code below.

CREATE TABLE friends (
id INTEGER,
name TEXT,
birthday DATE
);

INSERT INTO friends (id, name, birthday)
VALUES (1, ‘Ororo Munroe’, ‘1940-05-30’);

INSERT INTO friends (id, name, birthday)
VALUES (2, ‘Muneeb Afzal’, ‘1999-05-22’);

INSERT INTO friends (id, name, birthday)
VALUES (3, ‘Saba Zakar’, ‘2002-05-08’);

UPDATE friends
SET name = ‘Storm’
Where id = 1;

ALTER TABLE friends
ADD COLUMN email TEXT;

UPDATE friends
SET email = ‘[email protected]
Where id = 1;

SET email = ‘[email protected]
Where id = 2;

SET email = ‘[email protected]
Where id = 3;

DELETE FROM friends
WHERE id = 1;

SELECT * FROM friends;

You do have UPDATE friends before the SET email for the first entry.

But, you are missing UPDATE friends before the next two email entries.

1 Like

Hey, thanks for the fast response, I really appreciate it.

I’ve made the relevant changes and it has worked, thank you!

1 Like