/
employee_DB.sql
17 lines (16 loc) · 1.09 KB
/
employee_DB.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
CREATE TABLE employee (
id INT PRIMARY KEY,
first_name VARCHAR (120),
last_name VARCHAR (120),
department_id INT
);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (1, 'Bob', 'Estevez', 3);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (2, 'Francesca', 'Gotze', 2);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (3, 'Frank', 'Gordon', 2);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (4, 'Milicent', 'Johnson', 3);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (5, 'Hans', 'Handke', NULL);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (6, 'Katie', 'Keaton', 1);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (7, 'Luca', 'Di Francesco', NULL);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (8, 'Zoe', 'Jong', 1);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (9, 'Patrick', 'Rose', 2);
INSERT INTO employee (id, first_name, last_name, department_id) VALUES (10, 'Billie', 'Thompson', NULL);