IF NOT EXISTS (SELECT * FROM sys.databases d WHERE d.

name LIKE 'HR_DB')

CREATE DATABASE HR_DB;

GO
USE HR_DB;
GO

GO
CREATE TABLE dbo.Regions(
region_id INT
CONSTRAINT reg_region_id PRIMARY KEY,
region_name VARCHAR(50)
)

GO

CREATE TABLE dbo.Countries(

country_id CHAR(2)
CONSTRAINT ctr_country_id PRIMARY KEY,
country_name VARCHAR(40)
CONSTRAINT ctr_country_name_nn NOT NULL,
region_id INT
CONSTRAINT ctr_reg_fk REFERENCES dbo.Regions(region_id)
)

GO

CREATE TABLE dbo.Locations(

location_id INT
CONSTRAINT loc_location_id PRIMARY KEY,
street_address VARCHAR(50),
postal_code CHAR(12),
city VARCHAR(50),
state_province VARCHAR(50),
country_id CHAR(2)
CONSTRAINT loc_ctr_fk REFERENCES dbo.Countries(country_id)
)

GO

CREATE TABLE dbo.Jobs(

job_id VARCHAR(10)
CONSTRAINT job_joib_id PRIMARY KEY,
job_title VARCHAR(100)
CONSTRAINT job_job_title_nn NOT NULL,
min_salary NUMERIC(10, 2),
max_salary NUMERIC(10, 2)
)
GO

CREATE TABLE dbo.Departments(

department_id INT
CONSTRAINT dept_department_id PRIMARY KEY,
department_name VARCHAR(100),
manager_id INT,
location_id INT
CONSTRAINT dept_loc_fk REFERENCES dbo.Locations(location_id)
)
GO

CREATE TABLE dbo.Employees(

employee_id INT
CONSTRAINT emp_employee_id PRIMARY KEY,
first_name VARCHAR(20),
last_name VARCHAR(30) CONSTRAINT emp_last_name NOT NULL,
email VARCHAR(50)
CONSTRAINT emp_email_nn NOT NULL
CONSTRAINT emp_email_uk UNIQUE,
phone_number VARCHAR(20),
hire_date DATE
CONSTRAINT emp_hire_date_nn NOT NULL,
job_id VARCHAR(10)
CONSTRAINT emp_job_id_nn NOT NULL
CONSTRAINT emp_job_fk REFERENCES dbo.Jobs(job_id),
salary NUMERIC(10, 2)
CONSTRAINT emp_salary_ck CHECK (salary > 0),
commission_pct NUMERIC(6,2), -- commission percentage
manager_id INT,
department_id INT,
CONSTRAINT emp_dept_fk FOREIGN KEY(department_id) REFERENCES
dbo.Departments(department_id)
)
GO
ALTER TABLE dbo.Employees
ALTER COLUMN first_name NVARCHAR(20)

/*
ALTER Employee table
*/
-- Add constraint
ALTER TABLE Employees
ADD CONSTRAINT emp_manager_id_fk FOREIGN KEY (manager_id) REFERENCES
dbo.Employees(employee_id);

-- Add constraint to Department table

ALTER TABLE Departments
ADD CONSTRAINT dept_manager_id_fk FOREIGN KEY(manager_id) REFERENCES
Employees(employee_id);

GO
CREATE TABLE dbo.Job_History(
employee_id INT,
[start_date] DATE,
end_date DATE NOT NULL,
job_id VARCHAR(10),
department_id INT,
CONSTRAINT job_his_ck CHECK(start_date < end_date),
CONSTRAINT job_his_pk PRIMARY KEY (employee_id, start_date),
CONSTRAINT job_his_job_fk FOREIGN KEY(job_id) REFERENCES dbo.Jobs(job_id),
CONSTRAINT job_his_emp_fk FOREIGN KEY(employee_id) REFERENCES
dbo.Employees(employee_id),
CONSTRAINT job_his_dept_fk FOREIGN KEY (department_id) REFERENCES
dbo.Departments(department_id)
)
GO
-- THÊM DỮ LIỆU VÀO BẢNG REGIONS
INSERT INTO dbo.REGIONS (REGION_ID,REGION_NAME) VALUES (1,'Europe');
INSERT INTO dbo.REGIONS (REGION_ID,REGION_NAME) VALUES (2,'Americas');
INSERT INTO dbo.REGIONS (REGION_ID,REGION_NAME) VALUES (3,'Asia');
INSERT INTO dbo.REGIONS (REGION_ID,REGION_NAME) VALUES (4,'Middle East and
Africa');

GO
-- THÊM DỮ LIỆU VÀO BẢNG COUNTRIES
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('AR','Argentina',2);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('AU','Australia',3);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('BE','Belgium',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('BR','Brazil',2);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('CA','Canada',2);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('CH','Switzerland',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('CN','China',3);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('DE','Germany',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('DK','Denmark',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('EG','Egypt',4);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('FR','France',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('IL','Israel',4);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('IN','India',3);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('IT','Italy',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('JP','Japan',3);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('KW','Kuwait',4);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('ML','Malaysia',3);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('MX','Mexico',2);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('NG','Nigeria',4);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('NL','Netherlands',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('SG','Singapore',3);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('UK','United Kingdom',1);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('US','United States of America',2);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('ZM','Zambia',4);
INSERT INTO dbo.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES
('ZW','Zimbabwe',4);

GO
-- THÊM DỮ LIỆU VÀO BẢNG LOCATIONS

INSERT INTO dbo.LOCATIONS

(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1000,'1297 Via Cola di Rie','00989','Roma',null,'IT');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1100,'93091 Calle della Testa','10934','Venice',null,'IT');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1200,'2017 Shinjuku-ku','1689','Tokyo','Tokyo Prefecture','JP');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1300,'9450 Kamiya-cho','6823','Hiroshima',null,'JP');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1400,'2014 Jabberwocky Rd','26192','Southlake','Texas','US');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1500,'2011 Interiors Blvd','99236','South San Francisco','California','US');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1600,'2007 Zagora St','50090','South Brunswick','New Jersey','US');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1700,'2004 Charade Rd','98199','Seattle','Washington','US');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1800,'147 Spadina Ave','M5V 2L7','Toronto','Ontario','CA');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(1900,'6092 Boxwood St','YSW 9T2','Whitehorse','Yukon','CA');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2000,'40-5-12 Laogianggen','190518','Beijing',null,'CN');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2100,'1298 Vileparle (E)','490231','Bombay','Maharashtra','IN');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2200,'12-98 Victoria Street','2901','Sydney','New South Wales','AU');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2300,'198 Clementi North','540198','Singapore',null,'SG');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2400,'8204 Arthur St',null,'London',null,'UK');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2500,'Magdalen Centre, The Oxford Science Park','OX9
9ZB','Oxford','Oxford','UK');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2600,'9702 Chester Road','09629850293','Stretford','Manchester','UK');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2700,'Schwanthalerstr. 7031','80925','Munich','Bavaria','DE');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2800,'Rua Frei Caneca 1360 ','01307-002','Sao Paulo','Sao Paulo','BR');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(2900,'20 Rue des Corps-Saints','1730','Geneva','Geneve','CH');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(3000,'Murtenstrasse 921','3095','Bern','BE','CH');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(3100,'Pieter Breughelstraat 837','3029SK','Utrecht','Utrecht','NL');
INSERT INTO dbo.LOCATIONS
(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES
(3200,'Mariano Escobedo 9991','11932','Mexico City','Distrito Federal,','MX');

GO
-- THÊM DỮ LIỆU VÀO BẢNG JOBS
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('AD_PRES','President',20080,40000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('AD_VP','Administration Vice President',15000,30000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('AD_ASST','Administration Assistant',3000,6000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('FI_MGR','Finance Manager',8200,16000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('FI_ACCOUNT','Accountant',4200,9000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('AC_MGR','Accounting Manager',8200,16000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('AC_ACCOUNT','Public Accountant',4200,9000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('SA_MAN','Sales Manager',10000,20080);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('SA_REP','Sales Representative',6000,12008);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('PU_MAN','Purchasing Manager',8000,15000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('PU_CLERK','Purchasing Clerk',2500,5500);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('ST_MAN','Stock Manager',5500,8500);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('ST_CLERK','Stock Clerk',2008,5000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('SH_CLERK','Shipping Clerk',2500,5500);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('IT_PROG','Programmer',4000,10000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('MK_MAN','Marketing Manager',9000,15000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('MK_REP','Marketing Representative',4000,9000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('HR_REP','Human Resources Representative',4000,9000);
INSERT INTO dbo.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES
('PR_REP','Public Relations Representative',4500,10500);

GO
-- THÊM DỮ LIỆU VÀO BẢNG DEPARTMENTS
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(120,'Treasury',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (130,'Corporate
Tax',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (140,'Control
And Credit',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(150,'Shareholder Services',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(160,'Benefits',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(170,'Manufacturing',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(180,'Construction',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(190,'Contracting',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(200,'Operations',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (210,'IT
Support',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(220,'NOC',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (230,'IT
Helpdesk',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (240,'Government
Sales',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (250,'Retail
Sales',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(260,'Recruiting',null,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(270,'Payroll',null,1700);
GO
-- Run Statement nay truoc
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(100,'Dieu','Nguyen','dieunguyen','515.123.4568',CONVERT(VARCHAR,'21-SEP-
05',101),'AD_VP',17000,null,null,120);

-- Run cac Statements nay sau

INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(101,'Neena','Kochhar','NKOCHHAR','515.123.4568',CONVERT(VARCHAR,'21-SEP-
05',101),'AD_VP',17000,null,100,120);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (102,'Lex','De
Haan','LDEHAAN','515.123.4569',CONVERT(VARCHAR,'13-JAN-
01',101),'AD_VP',17000,null,100,120);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(103,'Alexander','Hunold','AHUNOLD','590.423.4567',CONVERT(VARCHAR,'03-JAN-
06',101),'IT_PROG',9000,null,102,130);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(104,'Bruce','Ernst','BERNST','590.423.4568',CONVERT(VARCHAR,'21-MAY-
07',101),'IT_PROG',6000,null,103,130);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(105,'David','Austin','DAUSTIN','590.423.4569',CONVERT(VARCHAR,'25-JUN-
05',101),'IT_PROG',4800,null,103, 130);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(106,'Valli','Pataballa','VPATABAL','590.423.4560',CONVERT(VARCHAR,'05-FEB-
06',101),'IT_PROG',4800,null,103,130);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(107,'Diana','Lorentz','DLORENTZ','590.423.5567',CONVERT(VARCHAR,'07-FEB-
07',101),'IT_PROG',4200,null,103,130);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(108,'Nancy','Greenberg','NGREENBE','515.124.4569',CONVERT(VARCHAR,'17-AUG-
02',101),'FI_MGR',12008,null,101,140);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(109,'Daniel','Faviet','DFAVIET','515.124.4169',CONVERT(VARCHAR,'16-AUG-
02',101),'FI_ACCOUNT',9000,null,108,140);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(110,'John','Chen','JCHEN','515.124.4269',CONVERT(VARCHAR,'28-SEP-
05',101),'FI_ACCOUNT',8200,null,108,140);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(111,'Ismael','Sciarra','ISCIARRA','515.124.4369',CONVERT(VARCHAR,'30-SEP-
05',101),'FI_ACCOUNT',7700,null,108,140);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (112,'Jose
Manuel','Urman','JMURMAN','515.124.4469',CONVERT(VARCHAR,'07-MAR-
06',101),'FI_ACCOUNT',7800,null,108,140);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(113,'Luis','Popp','LPOPP','515.124.4567',CONVERT(VARCHAR,'07-DEC-
07',101),'FI_ACCOUNT',6900,null,108,140);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(114,'Den','Raphaely','DRAPHEAL','515.127.4561',CONVERT(VARCHAR,'07-DEC-
02',101),'PU_MAN',11000,null,100,150);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(115,'Alexander','Khoo','AKHOO','515.127.4562',CONVERT(VARCHAR,'18-MAY-
03',101),'PU_CLERK',3100,null,114,150);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(116,'Shelli','Baida','SBAIDA','515.127.4563',CONVERT(VARCHAR,'24-DEC-
05',101),'PU_CLERK',2900,null,114,150);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(117,'Sigal','Tobias','STOBIAS','515.127.4564',CONVERT(VARCHAR,'24-JUL-
05',101),'PU_CLERK',2800,null,114,150);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(118,'Guy','Himuro','GHIMURO','515.127.4565',CONVERT(VARCHAR,'15-NOV-
06',101),'PU_CLERK',2600,null,114,150);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(119,'Karen','Colmenares','KCOLMENA','515.127.4566',CONVERT(VARCHAR,'10-AUG-
07',101),'PU_CLERK',2500,null,114,150);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(120,'Matthew','Weiss','MWEISS','650.123.1234',CONVERT(VARCHAR,'18-JUL-
04',101),'ST_MAN',8000,null,100,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(121,'Adam','Fripp','AFRIPP','650.123.2234',CONVERT(VARCHAR,'10-APR-
05',101),'ST_MAN',8200,null,100,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(122,'Payam','Kaufling','PKAUFLIN','650.123.3234',CONVERT(VARCHAR,'01-MAY-
03',101),'ST_MAN',7900,null,100,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(123,'Shanta','Vollman','SVOLLMAN','650.123.4234',CONVERT(VARCHAR,'10-OCT-
05',101),'ST_MAN',6500,null,100,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(124,'Kevin','Mourgos','KMOURGOS','650.123.5234',CONVERT(VARCHAR,'16-NOV-
07',101),'ST_MAN',5800,null,100,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(125,'Julia','Nayer','JNAYER','650.124.1214',CONVERT(VARCHAR,'16-JUL-
05',101),'ST_CLERK',3200,null,120,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(126,'Irene','Mikkilineni','IMIKKILI','650.124.1224',CONVERT(VARCHAR,'28-SEP-
06',101),'ST_CLERK',2700,null,120,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(127,'James','Landry','JLANDRY','650.124.1334',CONVERT(VARCHAR,'14-JAN-
07',101),'ST_CLERK',2400,null,120,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(128,'Steven','Markle','SMARKLE','650.124.1434',CONVERT(VARCHAR,'08-MAR-
08',101),'ST_CLERK',2200,null,120,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(129,'Laura','Bissot','LBISSOT','650.124.5234',CONVERT(VARCHAR,'20-AUG-
05',101),'ST_CLERK',3300,null,121,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(130,'Mozhe','Atkinson','MATKINSO','650.124.6234',CONVERT(VARCHAR,'21-AUG-
05',101),'ST_CLERK',2800,null,121,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(131,'James','Marlow','JAMRLOW','650.124.7234',CONVERT(VARCHAR,'16-FEB-
05',101),'ST_CLERK',2500,null,121,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(132,'TJ','Olson','TJOLSON','650.124.8234',CONVERT(VARCHAR,'10-APR-
07',101),'ST_CLERK',2100,null,121,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(133,'Jason','Mallin','JMALLIN','650.127.1934',CONVERT(VARCHAR,'14-JUN-
04',101),'ST_CLERK',3300,null,122,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(134,'Michael','Rogers','MROGERS','650.127.1834',CONVERT(VARCHAR,'26-AUG-
06',101),'ST_CLERK',2900,null,122,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(135,'Ki','Gee','KGEE','650.127.1734',CONVERT(VARCHAR,'12-DEC-
07',101),'ST_CLERK',2400,null,122,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(136,'Hazel','Philtanker','HPHILTAN','650.127.1634',CONVERT(VARCHAR,'06-FEB-
08',101),'ST_CLERK',2200,null,122,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(137,'Renske','Ladwig','RLADWIG','650.121.1234',CONVERT(VARCHAR,'14-JUL-
03',101),'ST_CLERK',3600,null,123,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(138,'Stephen','Stiles','SSTILES','650.121.2034',CONVERT(VARCHAR,'26-OCT-
05',101),'ST_CLERK',3200,null,123,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(139,'John','Seo','JSEO','650.121.2019',CONVERT(VARCHAR,'12-FEB-
06',101),'ST_CLERK',2700,null,123,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(140,'Joshua','Patel','JPATEL','650.121.1834',CONVERT(VARCHAR,'06-APR-
06',101),'ST_CLERK',2500,null,123,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(141,'Trenna','Rajs','TRAJS','650.121.8009',CONVERT(VARCHAR,'17-OCT-
03',101),'ST_CLERK',3500,null,124,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(142,'Curtis','Davies','CDAVIES','650.121.2994',CONVERT(VARCHAR,'29-JAN-
05',101),'ST_CLERK',3100,null,124,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(143,'Randall','Matos','RMATOS','650.121.2874',CONVERT(VARCHAR,'15-MAR-
06',101),'ST_CLERK',2600,null,124,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(144,'Peter','Vargas','PVARGAS','650.121.2004',CONVERT(VARCHAR,'09-JUL-
06',101),'ST_CLERK',2500,null,124,160);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(145,'John','Russell','JRUSSEL','011.44.1344.429268',CONVERT(VARCHAR,'01-OCT-
04',101),'SA_MAN',14000,0.4,100,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(146,'Karen','Partners','KPARTNER','011.44.1344.467268',CONVERT(VARCHAR,'05-
JAN-05',101),'SA_MAN',13500,0.3,100,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(147,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278',CONVERT(VARCHAR,'10
-MAR-05',101),'SA_MAN',12000,0.3,100,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(148,'Gerald','Cambrault','GCAMBRAU','011.44.1344.619268',CONVERT(VARCHAR,'15-
OCT-07',101),'SA_MAN',11000,0.3,100,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(149,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018',CONVERT(VARCHAR,'29-
JAN-08',101),'SA_MAN',10500,0.2,100,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(150,'Peter','Tucker','PTUCKER','011.44.1344.129268',CONVERT(VARCHAR,'30-JAN-
05',101),'SA_REP',10000,0.3,145,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(151,'David','Bernstein','DBERNSTE','011.44.1344.345268',CONVERT(VARCHAR,'24-
MAR-05',101),'SA_REP',9500,0.25,145,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(152,'Peter','Hall','PHALL','011.44.1344.478968',CONVERT(VARCHAR,'20-AUG-
05',101),'SA_REP',9000,0.25,145,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(153,'Cdboistopher','Olsen','COLSEN','011.44.1344.498718',CONVERT(VARCHAR,'30-
MAR-06',101),'SA_REP',8000,0.2,145,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(154,'Nanette','Cambrault','NCAMBRAU','011.44.1344.987668',CONVERT(VARCHAR,'09
-DEC-06',101),'SA_REP',7500,0.2,145,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(155,'Oliver','Tuvault','OTUVAULT','011.44.1344.486508',CONVERT(VARCHAR,'23-
NOV-07',101),'SA_REP',7000,0.15,145,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(156,'Janette','King','JKING','011.44.1345.429268',CONVERT(VARCHAR,'30-JAN-
04',101),'SA_REP',10000,0.35,146,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(157,'Patrick','Sully','PSULLY','011.44.1345.929268',CONVERT(VARCHAR,'04-MAR-
04',101),'SA_REP',9500,0.35,146,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(158,'Allan','McEwen','AMCEWEN','011.44.1345.829268',CONVERT(VARCHAR,'01-AUG-
04',101),'SA_REP',9000,0.35,146,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(159,'Lindsey','Smith','LSMITH','011.44.1345.729268',CONVERT(VARCHAR,'10-MAR-
05',101),'SA_REP',8000,0.3,146,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(160,'Louise','Doran','LDORAN','011.44.1345.629268',CONVERT(VARCHAR,'15-DEC-
05',101),'SA_REP',7500,0.3,146,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(161,'Sarath','Sewall','SSEWALL','011.44.1345.529268',CONVERT(VARCHAR,'03-NOV-
06',101),'SA_REP',7000,0.25,146,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(162,'Clara','Vishney','CVISHNEY','011.44.1346.129268',CONVERT(VARCHAR,'11-
NOV-05',101),'SA_REP',10500,0.25,147,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(163,'Danielle','Greene','DGREENE','011.44.1346.229268',CONVERT(VARCHAR,'19-
MAR-07',101),'SA_REP',9500,0.15,147,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(164,'Mattea','Marvins','MMARVINS','011.44.1346.329268',CONVERT(VARCHAR,'24-
JAN-08',101),'SA_REP',7200,0.1,147,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(165,'David','Lee','DLEE','011.44.1346.529268',CONVERT(VARCHAR,'23-FEB-
08',101),'SA_REP',6800,0.1,147,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(166,'Sundar','Ande','SANDE','011.44.1346.629268',CONVERT(VARCHAR,'24-MAR-
08',101),'SA_REP',6400,0.1,147,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(167,'Amit','Banda','ABANDA','011.44.1346.729268',CONVERT(VARCHAR,'21-APR-
08',101),'SA_REP',6200,0.1,147,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(168,'Lisa','Ozer','LOZER','011.44.1343.929268',CONVERT(VARCHAR,'11-MAR-
05',101),'SA_REP',11500,0.25,148,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(169,'Harrison','Bloom','HBLOOM','011.44.1343.829268',CONVERT(VARCHAR,'23-MAR-
06',101),'SA_REP',10000,0.2,148,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(170,'Tayler','Fox','TFOX','011.44.1343.729268',CONVERT(VARCHAR,'24-JAN-
06',101),'SA_REP',9600,0.2,148,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(171,'William','Smith','WSMITH','011.44.1343.629268',CONVERT(VARCHAR,'23-FEB-
07',101),'SA_REP',7400,0.15,148,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(172,'Elizabeth','Bates','EBATES','011.44.1343.529268',CONVERT(VARCHAR,'24-
MAR-07',101),'SA_REP',7300,0.15,148,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(173,'Sundita','Kumar','SKUMAR','011.44.1343.329268',CONVERT(VARCHAR,'21-APR-
08',101),'SA_REP',6100,0.1,148,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(174,'Ellen','Abel','EABEL','011.44.1644.429267',CONVERT(VARCHAR,'11-MAY-
04',101),'SA_REP',11000,0.3,149,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(175,'Alyssa','Hutton','AHUTTON','011.44.1644.429266',CONVERT(VARCHAR,'19-MAR-
05',101),'SA_REP',8800,0.25,149,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(176,'Jonathon','Taylor','JTAYLOR','011.44.1644.429265',CONVERT(VARCHAR,'24-
MAR-06',101),'SA_REP',8600,0.2,149,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(177,'Jack','Livingston','JLIVINGS','011.44.1644.429264',CONVERT(VARCHAR,'23-
APR-06',101),'SA_REP',8400,0.2,149,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(178,'Kimberely','Grant','KGRANT','011.44.1644.429263',CONVERT(VARCHAR,'24-
MAY-07',101),'SA_REP',7000,0.15,149,null);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(179,'Charles','Johnson','CJOHNSON','011.44.1644.429262',CONVERT(VARCHAR,'04-
JAN-08',101),'SA_REP',6200,0.1,149,170);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(180,'Winston','Taylor','WTAYLOR','650.507.9876',CONVERT(VARCHAR,'24-JAN-
06',101),'SH_CLERK',3200,null,120,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(181,'Jean','Fleaur','JFLEAUR','650.507.9877',CONVERT(VARCHAR,'23-FEB-
06',101),'SH_CLERK',3100,null,120,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(182,'Martha','Sullivan','MSULLIVA','650.507.9878',CONVERT(VARCHAR,'21-JUN-
07',101),'SH_CLERK',2500,null,120,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(183,'Girard','Geoni','GGEONI','650.507.9879',CONVERT(VARCHAR,'03-FEB-
08',101),'SH_CLERK',2800,null,120,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(184,'Nandita','Sarchand','NSARCHAN','650.509.1876',CONVERT(VARCHAR,'27-JAN-
04',101),'SH_CLERK',4200,null,121,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(185,'Alexis','Bull','ABULL','650.509.2876',CONVERT(VARCHAR,'20-FEB-
05',101),'SH_CLERK',4100,null,121,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(186,'Julia','Dellinger','JDELLING','650.509.3876',CONVERT(VARCHAR,'24-JUN-
06',101),'SH_CLERK',3400,null,121,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(187,'Anthony','Cabrio','ACABRIO','650.509.4876',CONVERT(VARCHAR,'07-FEB-
07',101),'SH_CLERK',3000,null,121,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(188,'Kelly','Chung','KCHUNG','650.505.1876',CONVERT(VARCHAR,'14-JUN-
05',101),'SH_CLERK',3800,null,122,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(189,'Jennifer','Dilly','JDILLY','650.505.2876',CONVERT(VARCHAR,'13-AUG-
05',101),'SH_CLERK',3600,null,122,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(190,'Timothy','Gates','TGATES','650.505.3876',CONVERT(VARCHAR,'11-JUL-
06',101),'SH_CLERK',2900,null,122,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(191,'Randall','Perkins','RPERKINS','650.505.4876',CONVERT(VARCHAR,'19-DEC-
07',101),'SH_CLERK',2500,null,122,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(192,'Sarah','Bell','SBELL','650.501.1876',CONVERT(VARCHAR,'04-FEB-
04',101),'SH_CLERK',4000,null,123,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(193,'Britney','Everett','BEVERETT','650.501.2876',CONVERT(VARCHAR,'03-MAR-
05',101),'SH_CLERK',3900,null,123,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(194,'Samuel','McCain','SMCCAIN','650.501.3876',CONVERT(VARCHAR,'01-JUL-
06',101),'SH_CLERK',3200,null,123,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(195,'Vance','Jones','VJONES','650.501.4876',CONVERT(VARCHAR,'17-MAR-
07',101),'SH_CLERK',2800,null,123,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(196,'Alana','Walsh','AWALSH','650.507.9811',CONVERT(VARCHAR,'24-APR-
06',101),'SH_CLERK',3100,null,124,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(197,'Kevin','Feeney','KFEENEY','650.507.9822',CONVERT(VARCHAR,'23-MAY-
06',101),'SH_CLERK',3000,null,124,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(198,'Donald','OConnell','DOCONNEL','650.507.9833',CONVERT(VARCHAR,'21-JUN-
07',101),'SH_CLERK',2600,null,124,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(199,'Douglas','Grant','DGRANT','650.507.9844',CONVERT(VARCHAR,'13-JAN-
08',101),'SH_CLERK',2600,null,124,180);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(200,'Jennifer','Whalen','JWHALEN','515.123.4444',CONVERT(VARCHAR,'17-SEP-
03',101),'AD_ASST',4400,null,101,190);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(201,'Michael','Hartstein','MHARTSTE','515.123.5555',CONVERT(VARCHAR,'17-FEB-
04',101),'MK_MAN',13000,null,100,190);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(202,'Pat','Fay','PFAY','603.123.6666',CONVERT(VARCHAR,'17-AUG-
05',101),'MK_REP',6000,null,201,190);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(203,'Susan','Mavris','SMAVRIS','515.123.7777',CONVERT(VARCHAR,'07-JUN-
02',101),'HR_REP',6500,null,101,190);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(204,'Hermann','Baer','HBAER','515.123.8888',CONVERT(VARCHAR,'07-JUN-
02',101),'PR_REP',10000,null,101,200);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(205,'Shelley','Higgins','SHIGGINS','515.123.8080',CONVERT(VARCHAR,'07-JUN-
02',101),'AC_MGR',12008,null,101,210);
INSERT INTO dbo.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,C
OMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES
(206,'William','Gietz','WGIETZ','515.123.8181',CONVERT(VARCHAR,'07-JUN-
02',101),'AC_ACCOUNT',8300,null,205,210);

GO
-- BỔ SUNG DỮ LIỆU VÀO BẢNG DEPARTMENTS
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(10,'Administration',200,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(20,'Marketing',201,1800);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(30,'Purchasing',114,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (40,'Human
Resources',203,2400);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(50,'Shipping',121,1500);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(60,'IT',103,1400);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (70,'Public
Relations',204,2700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(80,'Sales',145,2500);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(90,'Executive',100,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(100,'Finance',108,1700);
INSERT INTO dbo.DEPARTMENTS
(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES
(110,'Accounting',205,1700);

GO

-- THÊM DỮ LIỆU VÀO BẢNG JOB_HISTORY

GO

INSERT INTO dbo.JOB_HISTORY

(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(102,CONVERT(VARCHAR,'13-JAN-01',101),CONVERT(VARCHAR,'24-JUL-
06',101),'IT_PROG',120);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(101,CONVERT(VARCHAR,'21-SEP-97',101),CONVERT(VARCHAR,'27-OCT-
01',101),'AC_ACCOUNT',130);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(101,CONVERT(VARCHAR,'28-OCT-01',101),CONVERT(VARCHAR,'15-MAR-
05',101),'AC_MGR',130);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(201,CONVERT(VARCHAR,'17-FEB-04',101),CONVERT(VARCHAR,'19-DEC-
07',101),'MK_REP',140);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(114,CONVERT(VARCHAR,'24-MAR-06',101),CONVERT(VARCHAR,'31-DEC-
07',101),'ST_CLERK',150);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(122,CONVERT(VARCHAR,'01-JAN-07',101),CONVERT(VARCHAR,'31-DEC-
07',101),'ST_CLERK',150);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(200,CONVERT(VARCHAR,'17-SEP-95',101),CONVERT(VARCHAR,'17-JUN-
01',101),'AD_ASST',190);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(176,CONVERT(VARCHAR,'24-MAR-06',101),CONVERT(VARCHAR,'31-DEC-
06',101),'SA_REP',180);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(176,CONVERT(VARCHAR,'01-JAN-07',101),CONVERT(VARCHAR,'31-DEC-
07',101),'SA_MAN',180);
INSERT INTO dbo.JOB_HISTORY
(EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES
(200,CONVERT(VARCHAR,'01-JUL-02',101),CONVERT(VARCHAR,'31-DEC-
06',101),'AC_ACCOUNT',190);