Tutorial Preparation


CREATE TABLE users2 (
    USER_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(55),
    fav_color VARCHAR(20),
    has_pets TINYINT
);

INSERT INTO users2
(USER_ID, first_name, fav_color, has_pets)
VALUES
(NULL, "Bob", "blue", 6),
(NULL, NULL, "Green", 3),
(NULL, "Susie", "brownbrownbrown", 1),
(NULL, "Cindy", "green", 4),
(NULL, "Brian", "red", 3),
(NULL, "REbecca", "white", 3),
(NULL, "Daniel", "blue", 1),
(NULL, "Tim", "orange", 3),
(NULL, "Danielle", "babyblue", 1)