1.
Write a query to display the name ( first name and last name ) for those employee
who gets more salary than the employee whose ID is 163.
2. Write a query to display the name ( first name and last name ), salary, department id,
job id for those employees who works in same designation as the employee works
whose id is 169.
3. Write a query to display the name ( first name and last name ), salary, department id
for those employees who earn such amount of salary which is the smallest salary of any
department.
4. Write a query to display the employee id, employee name (first name and last name )
for all employees who earn more than the average salary.
5. Write a query to display the employee name ( first name and last name), employee id
and salary of all employees who report to Payam.
6. Write a query to display all the information of an employee whose salary and
reporting person id is 3000 and 121 respectively.
7. Display all the information of an employee whose id is any of the number 134, 159
and 183.
8. Write a query to display all the information of the employees whose salary is within
the range 1000 and 3000.
9. Write a query to display all the information of the employees whose salary if within
the range of smallest salary and 2500.
10. Write a query to display all the information for those employees whose id is any id
who earn second highest salary.
11. Write a query to display the employee name( first name and last name ) and
hiredate for all employees in the same department as Clara. Exclude Clara.
12. Write a query to display the employee number and name( first name and last name )
for all employees who work in a department with any employee whose name contains a
T.
13. Write a query to display the employee number, name( first name and last name ),
and salary for all employees who earn more than the average salary and who work in a
department with any employee with a J in their name.
14. Write a query to display the employee number, name( first name and last name )
and job title for all employees whose salary is smaller than any salary of those
employees whose job title is MK_MAN.
15. Write a query to display the employee number, name( first name and last name )
and job title for all employees whose salary is smaller than any salary of those
employees whose job title is MK_MAN. Exclude Job title MK_MAN.
16. Write a query to display the employee number, name( first name and last name )
and job title for all employees whose salary is more than any salary of those employees
whose job title is PU_MAN. Exclude job title PU_MAN.
17. Write a query to display the employee number, name( first name and last name )
and job title for all employees whose salary is more than any average salary of any
department.
18. Write a query to display the employee name( first name and last name ) and
department for all employees for any existence of those employees whose salary is
more than 3700.
19. Write a query to display the employee id, name ( first name and last name ) and the
job id column with a modified title SALESMAN for those employees whose job title is
ST_MAN and DEVELOPER for whose job title is IT_PROG.
20. Write a query to display the employee id, name ( first name and last name ), salary
and the SalaryStatus column with a title HIGH and LOW respectively for those
employees whose salary is more than and less than the average salary of all
employees.
21. Write a query to display the employee id, name ( first name and last name ),
SalaryDrawn, AvgCompare (salary - average salary of all employees) and the
SalaryStatus column with a title HIGH and LOW respectively for those employees
whose salary is more than and less than the average salary of all employees.
22. Write a query to determine who earns more than Mr. Ozer.
23. Write a query which is looking for the names of all employees whose salary is
greater than 50% of their department’s total salary bill.