DROP TABLE salgrade;

CREATE TABLE salgrade(
   grade number(4) not null,
   losal number(10,2),
   hisal number(10,2),
   CONSTRAINT salgrade_pk PRIMARY KEY (grade)
);

DROP TABLE dept;

CREATE TABLE dept(
   deptno number(2) not null,
   dname varchar(50) not null,
   loc varchar(50) not null,
   CONSTRAINT dept_pk PRIMARY KEY (deptno)
);

DROP TABLE emp;

CREATE TABLE emp(
   empno number(4) not null,
   ename varchar(50) not null,
   job varchar(50) not null,
   mgr number(4),
   hiredate date,
   sal number(10,2),
   comm number(10,2),
   deptno number(2) not null,
   CONSTRAINT emp_pk PRIMARY KEY (empno)
);

insert into dept values (10,'Accounting','New York');
insert into dept values (20,'Research','Dallas');
insert into dept values (30,'Sales','Chicago');
insert into dept values (40,'Operations','Boston');

insert into emp values (7369,'SMITH','CLERK',7902,'13-JUN-1993',800,0.00,20);
insert into emp values (7499,'ALLEN','SALESMAN',7698,'15-aug-98',1600,300.00,30);
insert into emp values (7521,'WARD','SALESMAN',7698,'26-mar-96',1250,500.00,30);
insert into emp values (7566,'JONES','MANAGER',7839,'31-oct-95',2975,null,20);
insert into emp values (7698,'BLAKE','MANAGER',7839,'11-jun-92',2850,null,30);
insert into emp values (7782,'CLARK','MANAGER',7839,'14-may-93',2450,null,10);
insert into emp values (7839,'KING','PRESIDENT',null,'9-jun-90',5000,0.00,10);
insert into emp values (7788,'SCOTT','ANALYST',7566,'5-mar-96',3000,null,20);
insert into emp values (7844,'TURNER','SALESMAN',7698,'4-jun-95',1500,0.00,30);
insert into emp values (7876,'ADAMS','CLERK',7788,'4-jun-99',1100,null,20);
insert into emp values (7900,'JAMES','CLERK',7698,'23-jun-00',950,null,30);
insert into emp values (7934,'MILLER','CLERK',7782,'21-jan-00',1300,null,10);
insert into emp values (7902,'FORD','ANALYST',7566,'5-dec-97',3000,null,20);
insert into emp values (7654,'MARTIN','SALESMAN',7698,'5-dec-98',1250,1400.00,30);

insert into salgrade values(1,700,1200);
insert into salgrade values(2,1201,1400);
insert into salgrade values(3,1401,2000);
insert into salgrade values(4,2001,3000);
insert into salgrade values(5,3001,99999);