SQL TEST PAPER EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 01-JAN-13 12.00.00 1 Jhon Abraham 1000000 Banking AM 01-JAN-13 12.00.00 2 Michael Clarke 800000 Insurance AM 01-FEB-13 12.00.00 3 Roy Thomas 700000 Banking AM 01-FEB-13 12.00.00 4 Tom Jose 600000 Insurance AM 01-FEB-13 12.00.00 5 Jerry Pinto 650000 Insurance AM 01-JAN-13 12.00.00 6 Philip Mathew 750000 Services AM 01-JAN-13 12.00.00 7 TestName1 123 650000 Services AM 01-FEB-13 12.00.00 8 TestName2 Lname% 600000 Insurance AM QUERIES (LEVEL 4) Table Name: Employee Table Name: Incentives EMPLOYEE_REF_ID INCENTIVE_DATE INCENTIVE_AMOUNT 1 01-FEB-13 5000 2 01-FEB-13 3000 3 01-FEB-13 4000 1 01-JAN-13 4500 2 01-JAN-13 3500 1.Select no of employees joined with respect to year and month from employee table 2. Select department, total salary with respect to a department from employee table where total salary greater than 800000 order by Total_Salary descending
SQL TEST PAPER QUERIES (LEVEL 4) Table Name: Employee EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 1 Jhon Abraham 1000000 01-JAN-13 12.00.00 AM Banking 2 Michael Clarke 800000 01-JAN-13 12.00.00 AM Insurance 3 Roy Thomas 700000 01-FEB-13 12.00.00 AM Banking 4 Tom Jose 600000 01-FEB-13 12.00.00 AM Insurance 5 Jerry Pinto 650000 01-FEB-13 12.00.00 AM Insurance 6 Philip Mathew 750000 01-JAN-13 12.00.00 AM Services 7 TestName1 123 650000 01-JAN-13 12.00.00 AM Services 8 TestName2 Lname% 600000 01-FEB-13 12.00.00 AM Insurance Table Name: Incentives EMPLOYEE_REF_ID INCENTIVE_DATE INCENTIVE_AMOUNT 1 01-FEB-13 5000 2 01-FEB-13 3000 3 01-FEB-13 4000 1 01-JAN-13 4500 2 01-JAN-13 3500 1.Select no of employees joined with respect to year and month from employee table 2. Select department, total salary with respect to a department from employee table where total salary greater than 800000 order by Total_Salary descending
4.%20LEVEL4.docx