Hi everyone!
I don’t understand why two tables “friends” appear.
I checked my code but do not see what is wrong with it… I would appreciate some help please!
Thank you a lot
CREATE TABLE friends(
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends (id, name, birthday)
VALUES (1, “Ororo Munroe”, “1940-05-30”),
(2, “Maxime M”, “1980-01-30”),
(3, “Anissa K”, “2000-09_17”);
SELECT *
FROM friends;
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