uh4aefpW

1DROP TABLE IF EXISTS emp;
2
3CREATE TABLE emp (
4  empno decimal(4,0) NOT NULL,
5  ename varchar(10) default NULL,
6  job varchar(9) default NULL,
7  mgr decimal(4,0) default NULL,
8  hiredate date default NULL,
9  sal decimal(7,2) default NULL,
10  comm decimal(7,2) default NULL,
11  deptno decimal(2,0) default NULL
12);
13
14DROP TABLE IF EXISTS dept;
15
16CREATE TABLE dept (
17  deptno decimal(2,0) default NULL,
18  dname varchar(14) default NULL,
19  loc varchar(13) default NULL
20);
21
22DROP TABLE IF EXISTS emp_bonus;
23
24CREATE TABLE emp_bonus (
25  empno decimal(4,0) default NULL,
26  received date default NULL,
27  type decimal(1,0) default NULL
28);
29
30INSERT INTO emp VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
31INSERT INTO emp VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
32INSERT INTO emp VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30');
33INSERT INTO emp VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
34INSERT INTO emp VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
35INSERT INTO emp VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
36INSERT INTO emp VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10');
37INSERT INTO emp VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20');
38INSERT INTO emp VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
39INSERT INTO emp VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
40INSERT INTO emp VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20');
41INSERT INTO emp VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
42INSERT INTO emp VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
43INSERT INTO emp VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
44
45INSERT INTO dept VALUES ('10','ACCOUNTING','NEW YORK');
46INSERT INTO dept VALUES ('20','RESEARCH','DALLAS');
47INSERT INTO dept VALUES ('30','SALES','CHICAGO');
48INSERT INTO dept VALUES ('40','OPERATIONS','BOSTON');
49
50INSERT INTO emp_bonus VALUES ('7934','2005-03-17','1');
51INSERT INTO emp_bonus VALUES ('7934','2005-02-15','2');
52INSERT INTO emp_bonus VALUES ('7839','2005-02-15','3');
53INSERT INTO emp_bonus VALUES ('7782','2005-02-15','1');