Q: 61-80

61. List the emps of Emp1 who are not found in deptno 20
62. Find the highest Sal of the Emp table.
63. Find the details of highest paid employee.

64. Find the highest paid employee of sales dept.
65. List the most recently hired emp of grade 3 belongs to the Loc CHICAGO
66. List the emps who are senior to most recently hired emp who is working under Mgr KING
67. List the details of emp belongs to New York with the Grade 3 to 5 except ‘PRESIDENT’ whose sal > the highest paid emp of CHICAGO in Group where there is ‘MANAGER’ & ‘ANALYST’ not working for Mgr KING
68. Display the details of most senior employee belongs to 1981.

69. List the emps who joined in 81 with job same as the most senior person of year 81.
70. List the most senior emp working under KING and Grade is more than 3.
71. Find the total sal given to the ‘MGR’
72. Find the total annual sal to distribute job wise in the year 81
73. Display the total sal of emps belong to Grade 3.
74. Display the avg salaries of all CLERKS
75. List the emps in dept 20 whose sal is > the avg sal of deptno 10 emps.
76. Display the number of emps for each job group deptno wise
77. List the Mgr no & no. of emps working for those Mgrs in the asc Mgrno.
78. List the dept details where at least two emps are working.
79. Display the grade, number of emps, max sal of each grade.
80. Display dname, grade, no of emps where atleast two emps are ‘CLERKS’