CREATE TABLE Employees (
employee_id int NOT NULL PRIMARY KEY,
first_name varchar(100),
last_name varchar(100),
salary float,
manager_id int,
department_id int
);
CREATE TABLE Departments (
department_id int NOT NULL PRIMARY KEY,
department_name VARCHAR(100),
manager_id int,
location_id int
);
INSERT INTO Employees VALUES(2,'Donald','OConnel',2600,124,50);
INSERT INTO Employees VALUES(3,'Douglas','Grant',1400,124,50);
INSERT INTO Employees VALUES(5,'Steven','King',3200,NULL,90);
INSERT INTO Employees VALUES(1,'Herman','Bear',10000,101,70);
INSERT INTO Employees VALUES(6,'Lorentz','Diana',4200,103,60);
INSERT INTO Employees VALUES(4,'Jeniffer','Whalen',4400,NULL,10);
INSERT INTO Employees VALUES(8,'David','Austin',4800,NULL,10);
INSERT INTO Employees VALUES(7,'Susan','Marris',6500,101,40);
INSERT INTO Employees VALUES(10,'Pat','Fay',6000,201,20);
INSERT INTO Employees VALUES(9,'Lex','DeHan',17000,100,90);
INSERT INTO Departments VALUES(10,'Administration',200,1700);
INSERT INTO Departments VALUES(20,'Marketing',201,1800);
INSERT INTO Departments VALUES(30,'Purchasing',114,1700);
INSERT INTO Departments VALUES(40,'Human Resource',203,2400);
INSERT INTO Departments VALUES(50,'Shipping',121,1500);
INSERT INTO Departments VALUES(60,'IT',103,1400);
INSERT INTO Departments VALUES(70,'Public Relations',204,2700);
INSERT INTO Departments VALUES(80,'Sales',145,2500);
INSERT INTO Departments VALUES(90,'Executive',100,1700);
INSERT INTO Departments VALUES(100,'Finance',108,1800);
