SQL EXERCICE 1

CREATE TABLE friends (id INTEGER, name TEXT , birthday DATE);
INSERT INTO friends (id, name, birthday)
VALUES (1 ,'Jane Doe', '1990-05-30');
SELECT *
FROM friends;
INSERT INTO friends (id, name, birthday)
VALUES (2, 'ashe', '1982-10-15');
INSERT INTO friends (id, name, birthday)
VALUES (3, 'mago', '1982-10-27');
UPDATE friends
SET name = 'Jane Smith'
WHERE id = 1;
ALTER TABLE friends
ADD COLUMN email;
UPDATE friends
SET email = 'jane@codecademy.com'
WHERE id = 1;
UPDATE friends
SET email = 'ashe@ashezar.com'
WHERE id = 2;
UPDATE friends
SET email = 'mago@gmail.com'
WHERE id = 3;
DELETE FROM friends
WHERE name IS 'Jane Smith';
SELECT * 
FROM friends;