ASSIGNMENTS ON OPERATORS IN SQL ~ NIIT POST

1. List all the employees in dept 20.
2. List the employee earning more than Rs 2500;
3. Display all the salesmen
4. List the employees in department 10 and 20.
5. List all the clerks and analyst.
6. List all the employee whose name starts with ‘S’
7. List all the employee whose name is having letter ‘L’ as Second character
8. List all the employees whose name is having at least 2 L’s in it
9. List the employees whose name is having letter ‘E’ as the last but one character
10. List all the employees whose name is having letter ‘R’ in the 3^rd position
11. List all the employees who are having exactly 5 characters in their jobs
12. Display employees from whose name is having letter ‘_’ in it
13. List the employees whose salary is between 2000 and 3000
14. List all the employees whose commission is null
15. List all the employees who don’t have a reporting manager
16. List all the salesmen in dept 30
17. List all the salesmen in dept number 30 and having salary greater than 1500
18. List all the employees whose name starts with ‘s’ or ‘a’
19. List all the employees except those who are working in dept 10 & 20.
20. List the employees whose name does not start with ‘S’
21. List all the employees who are having reporting managers in dept 10
22. Display all the employee who are getting 2500 and excess salaries in dept 20.
23. Display all the manager working in dept 20 and 30
24. Display all the employee whose job is manager who don’t have  Reporting manager
25. Display all the employee who are getting some commission with their designation is neither MANAGER not ANALYST
26. Display all the employee whose earning salary not in the range 2500 and 5000 in dept 10 and 20

27. Display all the manager whose annual sal is ending with zero
28. Display all the employees who are CLERK or ANALAYST with salary greater than 1000.
29. Display all the employee who are ‘SALESMAN’s having E as the last but one character in ename but salary having exactly 4 character
30. Display all the employee who are joined after year 81
31. Display all the employee who are joined in FEB
32. List the employees who are not working as managers and clerks in dept 10 and 20 with a salary in the range of 1000 to 3000
33.  List the employees whose salary not in the range of 1000 to 2000 in dept 10,20,30 except all salesmen
34.  List the department names which are having letter ‘O’ in their locations as well as their department names
35.  Display all the employees whose job has string ‘MAN’ in it.
36. Select all the employees whose name start with P or V in departmetment 10 and 20
37. Select all the salesman and clerks who are earcning salary in the range 1000 and 3000 except department 10
38. Select all the employees whose are joined before 01-may-81 and after 01-may-80
39. Select all the analyst whose name 3rd character start with 'S' and earning salary more than 2500
40. Select all the salesman whose salary not between 2000 and 3000 in depaertment 30