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;
