Hello All,
I am having problems with the project, nothing displays in the query after making the table. Can you look at my code and tell me what I am missing?
CREATE TABLE friends (id INTEGER, name TEXT, birthday DATE);
INSERT INTO friends (id, name, birthday)
VALUES (1, ‘Jane Doe’, 5/19/1993);
INSERT INTO friends (id, name, birthday)
VALUES (2, ‘Charlotte Viberry’, 4/22/2014);
INSERT INTO friends (id, name, birthday)
VALUES (3, ‘Annika Viberg’, 6/15/2012);
INSERT INTO friends (id, name, birthday)
VALUES (4, ‘Johan Wiberg’, 10/03/1978);
UPDATE friends
SET name = ‘Jane Smith’
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;
UPDATE friends
SET Email = ‘[email protected]’
WHERE id =4;
DELETE FROM friends WHERE id =1;
Thanks.