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


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

INSERT INTO friends (id, name, birthday) 
VALUES (2, "Rafa", "1999-04-20");

INSERT INTO friends (id, name, birthday) 
VALUES (3, "Sanlo", "1999-03-05");

UPDATE friends
SET name = "Storm"
WHERE name = "Ororo";

ALTER TABLE friends
ADD COLUMN email TEXT;

UPDATE friends
SET email = "storm@codecademy.comm"
WHERE name = "Storm";

UPDATE friends
SET email = "sanlo@codecademy.com"
WHERE name = "Sanlo";

UPDATE friends
SET email = "rafa@codecademy.com"
WHERE name = "Rafa";

DELETE FROM friends
WHERE id = 1;

SELECT * FROM friends