-
Notifications
You must be signed in to change notification settings - Fork 0
/
dataset.sql
16 lines (14 loc) · 913 Bytes
/
dataset.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
DROP TABLE IF EXISTS USER;
CREATE TABLE USER (
USER_ID INTEGER PRIMARY KEY NOT NULL,
FIRST_NAME VARCHAR NOT NULL,
LAST_NAME VARCHAR NOT NULL,
EMAIL VARCHAR NOT NULL,
GENDER VARCHAR NOT NULL,
AGE INTEGER NOT NULL
);
INSERT INTO USER(USER_ID, FIRST_NAME, LAST_NAME, EMAIL, GENDER, AGE) VALUES (1, 'Mikaël', 'Anzano', 'mikael.anzano@gmail.com', 'Mr', 29);
INSERT INTO USER(USER_ID, FIRST_NAME, LAST_NAME, EMAIL, GENDER, AGE) VALUES (2, 'Franck', 'Underwood', 'franck.underwood@fake.com', 'Mr', 58);
INSERT INTO USER(USER_ID, FIRST_NAME, LAST_NAME, EMAIL, GENDER, AGE) VALUES (3, 'Claire', 'Underwood', 'claire.underwood@fake.com', 'Mrs', 55);
INSERT INTO USER(USER_ID, FIRST_NAME, LAST_NAME, EMAIL, GENDER, AGE) VALUES (4, 'Walter', 'White', 'walter.white@fake.com', 'Mr', 60);
INSERT INTO USER(USER_ID, FIRST_NAME, LAST_NAME, EMAIL, GENDER, AGE) VALUES (5, 'Skyler', 'White', 'skyler.white@fake.com', 'Mrs', 25);