Codecademy export

project_1.sqlite

CREATE TABLE friends(
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends(id,name,birthday)
VALUES(1,'Ororo Munroe', '1940-05-30');
INSERT INTO friends (id ,name,birthday)
VALUES(2,'samir','1987-06-2');
INSERT INTO friends (id,name,birthday)
VALUES(3,'shrief','1988-09-3');
UPDATE friends
  SET name = 'Storm'
  WHERE id = 1;
SELECT * FROM friends;
ALTER TABLE friends
ADD COLUMN email TEXT;
SELECT * FROM friends;
UPDATE friends
SET email = 'storm@codecademy.com'
WHERE id = 1;
UPDATE friends
SET email = 'eng.samirgalal24@gmail.com'
WHERE id = 2;
UPDATE friends
SET email = 'Samir_galal24@yahoo.com'
WHERE id= 3;
SELECT * FROM friends;
DELETE FROM friends
WHERE name= 'samir';
SELECT* FROM friends;