Question no:2, MySQL

Language: Layout:

INSERT INTO EMPL4950(empno,ename,job,mgr,hiredate,sal,deptno)
VALUES(8369,'SMITH','CLERK',8902,'1990-12-18',800.00,20);
commit;
INSERT INTO EMPL4950
VALUES(8499,'ANYA','SALESMAN',8698, '1991-02-20',1600.00,300.00, 30);
commit;
INSERT INTO EMPL4950
VALUES(8521,'SETH','SALESMAN', 8698,'1991-02-22',1250.00,500.00, 30);
commit;
INSERT INTO EMPL4950(empno,ename, job,mgr,hiredate,sal,deptno)
VALUES(8566,'MAHADEVAN','MANAGER',8839,'1991-04-02',2986.00,20);
commit;
INSERT INTO EMPL4950
VALUES(8654,'MOMIN','SALESMAN',8698,'1991-09-28',1250.00,1400.00,30);
commit;
INSERT INTO EMPL4950(empno,ename,job,mgr,hiredate,sal,deptno)
VALUES(8698,'BINA','MANAGER',8889,'1991-05-01',2850.00,30);
commit;
INSERT INTO EMPL4950(empno,ename,job,mgr,hiredate,sal,deptno)
VALUES(8882,'SHIAVNSH','MANAGER', 8839,'1991-06-09',2450.00,10);
commit;
INSERT INTO EMPL4950(empno,ename,job,mgr,hiredate,sal,deptno)
VALUES(5888,'SCOIT','ANALYST',8566, '1992-12-09',3000.00,20);
commit;
INSERT INTO EMPL4950(empno,ename,job,hiredate,sal,deptno)
VALUES(8839,'AMIR','PRESIDENT','1991-11-18',5000.00,10);
commit;
INSERT INTO EMPL4950
VALUES(8844,'KULDEEP','SALESMAN',8698,'1991-09-08',1500.00,0.00,30);
commit;
INSERT INTO EMPL4950(empno,ename, job,mgr,hiredate,sal,deptno)
VALUES(8886,'ANOOP','CLERK',8888,'1993-01-12',1100.00,20);
commit;
INSERT INTO EMPL4950(empno,ename,job,mgr,hiredate,sal,deptno)
VALUES(8900,'JAIN','CLERK',8698,'1991-12-03',950.00,30);
commit;
INSERT INTO EMPL4950(empno, ename, job, mgr, hiredate, sal, deptno)
VALUES(8902,'FAKIR','ANALYST',8566,'1991-12-05',3000.00,20);
commit;
INSERT INTO EMPL4950(empno,ename, job,mgr,hiredate,sal,deptno)
VALUES(8934,'MITA','CLERK',8882,'1992-01-23',1300.00,10);
commit;


absolute service time: 0,37 sec