create table EMPLOYEES(EMPNO integer(4) NOT NULL,ENAME varchar(10),YOMI varchar(20),JOB varchar(8),MGR integer(4),HIREDATE date,SAL varchar(7),COMM integer(7),DEPTNO integer(2));
create table DEPATMENTS(DEPTNO integer(2), DNAME varchar(10), LOC varchar(10));
INSERT INTO EMPLOYEES VALUES (1001,"佐藤","sato","社長",null,'2001-02-25',500000,null,10);
INSERT INTO EMPLOYEES VALUES (1002,"鈴木","suzuki","事務",1013,'2000-03-26',200000,null,20);
INSERT INTO EMPLOYEES VALUES (1003,"高橋","takaha","営業",1007,'2000-05-30',300000,300000,30);
INSERT INTO EMPLOYEES VALUES (1004,"田中","tanaka","営業",1007,'2002-06-02',355000,500000,30);
INSERT INTO EMPLOYEES VALUES (1005,"渡辺","watana","部長",1001,'2002-07-11',280000,null,20);
INSERT INTO EMPLOYEES VALUES (1006,"伊藤","ito","営業",1007,'2008-01-06',300000,140000,30);
INSERT INTO EMPLOYEES VALUES (1007,"山本","yamamo","部長",1001,'2000-08-09',285000,null,30);
INSERT INTO EMPLOYEES VALUES (1008,"中村","nakamu","部長",1001,'2000-09-17',245000,null,10);
INSERT INTO EMPLOYEES VALUES (1009,"小林","kobaya","主任",1005,'2006-10-21',300000,null,20);
INSERT INTO EMPLOYEES VALUES (1010,"斎藤","saito","営業",1007,'2001-12-17',150000,0,30);
INSERT INTO EMPLOYEES VALUES (1011,"加藤","Kato","事務",1009,'2006-10-21',110000,null,20);
INSERT INTO EMPLOYEES VALUES (1012,"吉田","yoshida","事務",1007,'2009-03-13',295000,null,30);
INSERT INTO EMPLOYEES VALUES (1013,"山田","Yamada","主任",1005,'2001-03-13',280000,null,20);
INSERT INTO EMPLOYEES VALUES (1014,"佐々木","sasaki","事務",1008,'2004-05-02',230000,null,10);
INSERT INTO DEPATMENTS VALUES (10,"管理","大手町");
INSERT INTO DEPATMENTS VALUES (20,"研究開発","横浜");
INSERT INTO DEPATMENTS VALUES (30,"営業","品川");
INSERT INTO DEPATMENTS VALUES (40,"財務","東京");