Created
November 28, 2017 01:16
-
-
Save hiraksarkar/4cef1ecaa90b60129cfa5160fb646615 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP TABLE IF EXISTS emp; | |
CREATE TABLE emp ( | |
empno decimal(4,0) NOT NULL, | |
ename varchar(10) default NULL, | |
job varchar(9) default NULL, | |
mgr decimal(4,0) default NULL, | |
hiredate date default NULL, | |
sal decimal(7,2) default NULL, | |
comm decimal(7,2) default NULL, | |
deptno decimal(2,0) default NULL | |
); | |
DROP TABLE IF EXISTS dept; | |
CREATE TABLE dept ( | |
deptno decimal(2,0) default NULL, | |
dname varchar(14) default NULL, | |
loc varchar(13) default NULL | |
); | |
DROP TABLE IF EXISTS emp_bonus; | |
CREATE TABLE emp_bonus ( | |
empno decimal(4,0) default NULL, | |
received date default NULL, | |
type decimal(1,0) default NULL | |
); | |
INSERT INTO emp VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20'); | |
INSERT INTO emp VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30'); | |
INSERT INTO emp VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30'); | |
INSERT INTO emp VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20'); | |
INSERT INTO emp VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30'); | |
INSERT INTO emp VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30'); | |
INSERT INTO emp VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10'); | |
INSERT INTO emp VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20'); | |
INSERT INTO emp VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10'); | |
INSERT INTO emp VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30'); | |
INSERT INTO emp VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20'); | |
INSERT INTO emp VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30'); | |
INSERT INTO emp VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20'); | |
INSERT INTO emp VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10'); | |
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_bonus VALUES ('7934','2005-03-17','1'); | |
INSERT INTO emp_bonus VALUES ('7934','2005-02-15','2'); | |
INSERT INTO emp_bonus VALUES ('7839','2005-02-15','3'); | |
INSERT INTO emp_bonus VALUES ('7782','2005-02-15','1'); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment