create table emp (EMPNO int,ENAME varchar(20),JOB varchar(20),MGR int, HIREDATE int, SAL int, COMM int,DEPTNO int);
insert into emp values(7369,'claude','chercheur',7902,20061217,800,null,20);
insert into emp values(7499,'reichstadt','vendeur',7698,20060220,1600,300,30);
insert into emp values(7521,'liauzu','vendeur',7698,20060222,1250,500,30);
insert into emp values(7566,'mahul','manager',7839,20060402,2975,null,20);
insert into emp values(7654,'salzemann','vendeur',7698,20060908,1250,1400,30);
insert into emp values(7698,'bloch','manager',7839,20060501,2850,null,30);
insert into emp values(7782,'dacosta','manager',7839,20060609,2450,null,10);
insert into emp values(7788,'fettahi','analyste',7566,20020419,3000,null,20);
insert into emp values(7839,'massendari','PRESIDENT',null,20061117,5000,null,10);
insert into emp values(7844,'breton','vendeur',7698,20060908,1500,null,30);
insert into emp values(7876,'peyret','chercheur',7788,20020523,1100,null,20);
insert into emp values(7900,'leroy','chercheur',7698,20061203,950,null,30);
insert into emp values(7902,'perez','analyste',7566,20061203,3000,null,20);
insert into emp values(7934,'boisart','chercheur',7782,20070123,1300,null,10);
create table dept (DEPTNO int,DNAME varchar(20),LOC varchar(20));
insert into dept values(10,'presidence','gueret');
insert into dept values(20,'recherche','clermont');
insert into dept values(30,'vente','aurillac');
insert into dept values(40,'operations','monlucon');
