Lab 7

  1. Write a query in SQL to list the employees who are senior to Greenberg (LASTNAME)
    Explanation: "senior" = employed before
  2. Write a query in SQL to list the employees whose salary is same as the salary of FRANK or SANDRINE. List the result in descending order of salary.
  3. Write a query in SQL to list the employees whose salary is more than the total remuneration of the SALESMAN.
  4. Write a query in SQL to find the total salary given to the MANAGER
  5. Write a query in SQL to list the employees in department 90 whose salary is more than the average salary of employees in department 100
  6. Write a query in SQL to list the details of the departments where the maximum number of employees are working.
  7. Write a query in SQL to list the name of the employees who are getting the highest salary of each department.
  8. Write a query in SQL to list the employees whose salary is less than the salary of his manager but more than the salary of any other manager.
  9. Write a query in SQL to find out the least 5 earners of the company.
  10. Write a query in SQL to list the employees who joined in the company on the same date.
Solutions...
Home