Mysql emp dept

EMP

CREATE TABLE EMP

(EMPNO int NOT NULL,

ENAME VARCHAR(10),

JOB VARCHAR(9),

MGR int,

HIREDATE DATE,

SAL double(7, 2),

COMM double(7, 2),

DEPTNO int);

INSERT INTO EMP VALUES

(7369, 'SMITH',  'CLERK',    7902,

str_to_date('17-DEC-1980', '%e-%M-%Y'),  800, NULL, 20);

INSERT INTO EMP VALUES

(7499, 'ALLEN',  'SALESMAN',  7698,

str_to_date('20-FEB-1981', '%e-%M-%Y'), 1600,  300, 30);

INSERT INTO EMP VALUES

(7521, 'WARD',  'SALESMAN',  7698,

str_to_date('22-FEB-1981', '%e-%M-%Y'), 1250,  500, 30);

INSERT INTO EMP VALUES

(7566, 'JONES',  'MANAGER',  7839,

str_to_date('2-APR-1981', '%e-%M-%Y'),  2975, NULL, 20);

INSERT INTO EMP VALUES

(7654, 'MARTIN', 'SALESMAN',  7698,

str_to_date('28-SEP-1981', '%e-%M-%Y'), 1250, 1400, 30);

INSERT INTO EMP VALUES

(7698, 'BLAKE',  'MANAGER',  7839,

str_to_date('1-MAY-1981', '%e-%M-%Y'),  2850, NULL, 30);

INSERT INTO EMP VALUES

(7782, 'CLARK',  'MANAGER',  7839,

str_to_date('9-JUN-1981','%e-%M-%Y'),  2450, NULL, 10);

INSERT INTO EMP VALUES

(7788, 'SCOTT',  'ANALYST',  7566,

str_to_date('09-DEC-1982','%e-%M-%Y'), 3000, NULL, 20);

INSERT INTO EMP VALUES

(7839, 'KING',  'PRESIDENT', NULL,

str_to_date('17-NOV-1981', '%e-%M-%Y'), 5000, NULL, 10);

INSERT INTO EMP VALUES

(7844, 'TURNER', 'SALESMAN',  7698,

str_to_date('8-SEP-1981', '%e-%M-%Y'),  1500,    0, 30);

INSERT INTO EMP VALUES

(7876, 'ADAMS',  'CLERK',    7788,

str_to_date('12-JAN-1983', '%e-%M-%Y'), 1100, NULL, 20);

INSERT INTO EMP VALUES

(7900, 'JAMES',  'CLERK',    7698,

str_to_date('3-DEC-1981', '%e-%M-%Y'),  950, NULL, 30);



INSERT INTO EMP VALUES

(7902, 'FORD',  'ANALYST',  7566,

str_to_date('3-DEC-1981', '%e-%M-%Y'),  3000, NULL, 20);

INSERT INTO EMP VALUES

(7934, 'MILLER', 'CLERK',    7782,

str_to_date('23-JAN-1982','%e-%M-%Y'), 1300, NULL, 10);

DEPT

CREATE TABLE DEPT

(DEPTNO integer,

DNAME VARCHAR(14),

LOC VARCHAR(13) );

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');