SQL Questions For Practice--->I

1.Display employee number and total salary for each employee

2. Display the names of employees who earn Highest salaries in their respective job

Groups?

3. Display the employee names who are Working in Chicago?

4. Display the job groups having Total Salary greater than the maximum salary for

Managers?

5. Display the information from the employee table . where ever job Manager is found it should be displayed as Boss?

6. Display those employees whose name contains not less than 4 characters?

7. Display those employees whose salary is more than 3000 after giving 20%

    Increment

8. Display employee name,dept name,salary,and commission for those sal in between

  2000   to 5000 while location is Chicago?

9. Update the salary of each employee by 10% increment  who are not eligible for commission?

10. List out all the employee names ,job,salary,grade and deptname for every one in a    company  except 'CLERK' . Sort on salary display the highest salary?

11. Display those employees whose salary  is equal to average of maximum and minimum?

12. Display name of those managers name whose salary is more than average salary of

      Company?

13. Delete those records from emp table  whose deptno not available in dept table?

14.Display those enames whose salary is out of grade available  in salgrade table?

15. Display those employees whose name  contains A?        

16. ) Delete those employeewho joined the company 10 years back from today?

17. Count the number of employees who are working as managers (Using set    opetrator)?

18. List out the employee name and salary increased by 15% and express as whole number of  Dollars?

19. Display those managers who are getting less than his employees salary?

20. .Display those employees whose manager name is JONES and also with his manager name