CREATE TABLE friends (
  id INTEGER,
  name TEXT,
  birthday DATE 
);
 
INSERT INTO friends (id,name, birthday)
VALUES (1,'Ororo Munroe', 'May 30th, 1940');
 
 
 
INSERT INTO friends (id,name, birthday)
VALUES (2,'Edward Nylander', 'July 30th, 1958');
 
INSERT INTO friends (id,name, birthday)
VALUES (3,'Taylor Olson', 'February 20th, 1958');
 
UPDATE friends
SET name = 'Storm'
WHERE id = 1;
 
ALTER TABLE friends
ADD email TEXT;
 
UPDATE friends
SET email = 'storm@codeacademy.com'
WHERE id = 1;
UPDATE friends
SET email = 'randomnumber@mst.edu'
WHERE id = 2;
UPDATE friends
SET email = 'manimissmydawgs@gmail.com'
WHERE id = 3;
 
--DELETE FROM friends
--WHERE id = 1;
 
SELECT * FROM friends;