Assignment#9

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Assignment#9 as PDF for free.

More details

  • Words: 209
  • Pages: 1
Assignment #9 ========== 1. FIND THE MOST EXPERIENCED ANALYST OF THE COMPANY. 2. COUNT ALL EMPLOYEES WHO WERE HIRED AFTER 22-MAR-81. 3. LIST ALL EMPLOYEES WHO ARE GETTING LESS THAN THE AVERAGE SALARIES OF THEIR DEPARTMENTS. 4. FIND THE JOB WHICH HAS THE HIGHEST AVERAGE SALARY 5. FIND THE THREE MINIMUM SALARY IN EACH DEPARTMENT. 6. FIND THIRD HIGHEST EARNER IN THE COMPANY. 7. FIND ALL EMPLOYEES WHO EARN MORE THAN ANY EMPLOYEE IN DEPARTMENT 30. 8. FIND ALL JOBS WITH EITHER THE SAME JOB AS JONES OR SALARY GREATER THAN OR EQUAL TO FORD. ORDER BY JOB AND SAL. 9. FIND ALL EMPLOYEES WHOSE JOBS ARE SAME AS THE JOB OF MANAGER OF THE SMITH. 10. FIND ALL EMPLOYEES WHO WERE HIRED AFTER SMITH BUT EARN GREATER THAN SMITH. 11. FIND ALL EMPLOYEES WHO WERE HIRED IN SAME DEPARTMENT OF KING. 12. FIND ALL EMPLOYEES WHO REPORT TO KING. 13. FIND ALL EMPLOYEES WHO WORK IN NEW YORK CITY. 14. FIND ALL EMPLOYEES OF GRADE 3 WHO WORK IN THE SAME DEPARTMENT WHERE SCOTT WORKS. 15. LIST ALL EMPLOYEES OF GRADE 1 WORKING IN THE RESEARCH DEPARTMENT AND REPORTING TO JONES. Practice Make Perfect. This Is Just Beginning Of Oracle Tracks�� Good Luck For OCP Test & Future.