SQL: Create, insert, Alter, Update, Delete and Select.

database.sql

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

INSERT INTO friends (id, name, birthday) 
VALUES 
  (1, 'Jane Doe', '1990-05-30'),
  (2, 'Richard Stallman', '1953-03-16'),
  (3, 'Enzo Carella', '1952-01-08');
  
UPDATE friends
SET name = 'Jane Smith'
WHERE id = 1;

ALTER TABLE friends
ADD COLUMN email TEXT;

UPDATE friends
SET email = 'jane@codecademy.com'
WHERE id = 1;

UPDATE friends
SET email = 'richard@xilab.co'
WHERE id = 2;

UPDATE friends
SET email = 'enzo@xilab.co'
WHERE id = 3;

DELETE FROM friends
WHERE id = 1;

SELECT * FROM friends;