#1

CREATE TABLE people(
	id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
	birth_date DATE NOT NULL    
);

#2

INSERT INTO people(first_name,last_name,birth_date)
VALUES('John','Doe','1990-09-01');

#3

SELECT 
    first_name, last_name, birth_date
FROM
    people;

#4

INSERT INTO people(first_name,last_name,birth_date)
VALUES('Jack','Daniel','01-09-01'),
      ('Lily','Bush','80-09-01');

#5

SELECT 
    first_name, last_name, birth_date
FROM
    people;

#5

SELECT DATEDIFF('2015-11-04','2014-11-04') days;

#6

SELECT NOW();

#7

SELECT DATE(NOW());

#8

SELECT CURDATE();

#9

SELECT DATE_FORMAT(CURDATE(), '%m/%d/%Y');

#11

SELECT 
    '2015-01-01',
    DATE_ADD('2015-01-01', INTERVAL 1 DAY) 'one day later',
    DATE_ADD('2015-01-01', INTERVAL 1 WEEK) 'one week later',
    DATE_ADD('2015-01-01', INTERVAL 1 MONTH) 'one month later',
    DATE_ADD('2015-01-01', INTERVAL 1 YEAR) 'one year later';

#12

SELECT 
    '2015-01-01',
    DATE_SUB('2015-01-01', INTERVAL 1 DAY) 'one day before',
    DATE_SUB('2015-01-01', INTERVAL 1 WEEK) 'one week before',
    DATE_SUB('2015-01-01', INTERVAL 1 MONTH) 'one month before',
    DATE_SUB('2015-01-01', INTERVAL 1 YEAR) 'one year before';

#13

SELECT DAY('2000-12-31') day, 
       MONTH('2000-12-31') month, 
       QUARTER('2000-12-31') quarter, 
       YEAR('2000-12-31') year;

#14

SELECT 
    WEEKDAY('2000-12-31'),
    WEEK('2000-12-31'),
    WEEKOFYEAR('2000-12-31');

#15

SELECT 
    WEEKDAY('2000-12-31'),
    WEEK('2000-12-31',1),
    WEEKOFYEAR('2000-12-31');