create table Employee
(
emp_id decimal (12) not null primary key,
fname varchar (32),
lname varchar (32),
job_name varchar (255),
salary decimal (32),
manager_id decimal (12),
department_id decimal (12)
);

insert into Employee
(
emp_id,
fname,
lname,
job_name,
salary,
manager_id,
department_id
)
values
(100,'Bob','Marley','Programmer',240000,01,1001),
(101,'Craig','David','Accountant',220000,02,1002),
(102,'Steven','Hock','Salesman',3000,03,1003),
(103,'Bradley','Cooper','PR',4000,04,1004),
(104,'Adam','Levian','Audit',5000,05,1005),
(105,'Mark','May','Tax specialist',6000,08,1004),
(106,'Arthur','King','Finance',7000,02,1002),
(107,'Daniel','Faviet','Programmer',3200,01,1000),
(108,'Karen','Dias','IT Manager',100000,03,1004),
(109,'James','Oliver','HR',7000,01,1005),
(110,'Jay','Shuttle','Audit',5000,05,1000),
(111,'Harry','Potter','Programmer',45000,02,1005),
(112,'Ki','Gee','Salesman',300000,04,1002),
(113,'Peter','Vargas','QA',100000,03,1001),
(114,'Winston','Taylor','PR',12000,03,1006),
(115,'Kelly','Chung','Finance',39000,06,1007),
(116,'Kenny','Freenay','Economist',5000,07,1007),
(117,'Shirley','Higgins','Salesman',400,03,1009),
(118,'Donald','Cornell','Programmer',300000,01,1009);