create table sawon
(sabun int not null,
saname varchar(10),
sajob varchar(10),
manager int,
hiredate datetime,
sal int,
comm int,
deptno int)
create table dept
(deptno int,
deptname varchar(20),
location varchar(10))
create table salary
(grade int,
losal int,
hisal int)
insert into sawon values(1001,'tom','clerk',2003,'1992-10-3',152,16,20)
insert into sawon values(1003,'john','clerk',3002,'1997-5-6',266,20,20)
insert into sawon values(1007,'bill','manager',2001,'2001-5-7',120,36,30)
insert into sawon values(1008,'ann','analyst',2006,'1995-1-2',166,100,10)
insert into sawon values(2003,'smith','engineer',2003,'2000-12-4',360,24,40)
insert into sawon values(2005,'adams','engineer',2001,'2005-6-8',300,null,10)
insert into sawon values(2001,'mike','director',4005,'1999-8-9',269,5,10)
insert into sawon values(4005,'hong','chief',2001,'1988-8-4',340,46,20)
insert into sawon values(3008,'kim','manager',5002,'2003-6-4',198,30,10)
insert into sawon values(5007,'lee','director',5002,'1996-5-8',250,null,10)
insert into sawon values(1006,'park','analyst',4005,'1997-11-5',164,88,30)
insert into sawon values(2002,'lim','engineer',2006,'1994-3-8',480,95,40)
insert into sawon values(3009,'choi','director',1007,'2000-7-7',360,null,40)
insert into sawon values(3002,'martin','manager',3002,'2000-8-9',320,6,20)
insert into sawon values(4002,'bae','analyst',2006,'1994-10-16',168,21,10)
insert into sawon values(2006,'jongmin','chairman',2006,'1995-6-22',700,200,50)
insert into sawon values(5002,'yunjin','director',4005,'1997-9-6',620,null,40)
insert into sawon values(3003,'misook','chief',2006,'2003-9-4',168,32,50)
insert into sawon values(6004,'dongsu','analyst',2003,'1994-10-18',157,5,30)
insert into sawon values(7005,'kang','chief',3008,'1985-8-8',244,3,10)
insert into dept values(10,'sales','seoul')
insert into dept values(20,'human','deagu')
insert into dept values(30,'consult','pusan')
insert into dept values(40,'research','wonju')
insert into dept values(50,'accounting','jeju')
insert into salary values(1,0,99)
insert into salary values(2,100,199)
insert into salary values(3,200,299)
insert into salary values(4,300,399)
insert into salary values(5,400,499)
insert into salary values(6,500,1000)
(sabun int not null,
saname varchar(10),
sajob varchar(10),
manager int,
hiredate datetime,
sal int,
comm int,
deptno int)
create table dept
(deptno int,
deptname varchar(20),
location varchar(10))
create table salary
(grade int,
losal int,
hisal int)
insert into sawon values(1001,'tom','clerk',2003,'1992-10-3',152,16,20)
insert into sawon values(1003,'john','clerk',3002,'1997-5-6',266,20,20)
insert into sawon values(1007,'bill','manager',2001,'2001-5-7',120,36,30)
insert into sawon values(1008,'ann','analyst',2006,'1995-1-2',166,100,10)
insert into sawon values(2003,'smith','engineer',2003,'2000-12-4',360,24,40)
insert into sawon values(2005,'adams','engineer',2001,'2005-6-8',300,null,10)
insert into sawon values(2001,'mike','director',4005,'1999-8-9',269,5,10)
insert into sawon values(4005,'hong','chief',2001,'1988-8-4',340,46,20)
insert into sawon values(3008,'kim','manager',5002,'2003-6-4',198,30,10)
insert into sawon values(5007,'lee','director',5002,'1996-5-8',250,null,10)
insert into sawon values(1006,'park','analyst',4005,'1997-11-5',164,88,30)
insert into sawon values(2002,'lim','engineer',2006,'1994-3-8',480,95,40)
insert into sawon values(3009,'choi','director',1007,'2000-7-7',360,null,40)
insert into sawon values(3002,'martin','manager',3002,'2000-8-9',320,6,20)
insert into sawon values(4002,'bae','analyst',2006,'1994-10-16',168,21,10)
insert into sawon values(2006,'jongmin','chairman',2006,'1995-6-22',700,200,50)
insert into sawon values(5002,'yunjin','director',4005,'1997-9-6',620,null,40)
insert into sawon values(3003,'misook','chief',2006,'2003-9-4',168,32,50)
insert into sawon values(6004,'dongsu','analyst',2003,'1994-10-18',157,5,30)
insert into sawon values(7005,'kang','chief',3008,'1985-8-8',244,3,10)
insert into dept values(10,'sales','seoul')
insert into dept values(20,'human','deagu')
insert into dept values(30,'consult','pusan')
insert into dept values(40,'research','wonju')
insert into dept values(50,'accounting','jeju')
insert into salary values(1,0,99)
insert into salary values(2,100,199)
insert into salary values(3,200,299)
insert into salary values(4,300,399)
insert into salary values(5,400,499)
insert into salary values(6,500,1000)
