SQL Assignment 4 - sayanbhattacharya1234/Oracle_DBA GitHub Wiki

1.Display all columns from the employees table.

2.Display the first_name and last_name of all employees.

3.Display the employee_id, job_id, and salary of all employees.

4.Display employees whose salary is greater than 10000.

5.Display employees whose salary is less than 5000.

6.Display employees who belong to department_id = 90.

7.Display employees who work as 'IT_PROG'.

8.Display employees whose salary is between 8000 and 12000.

9.Display employees whose department_id is 10, 20, 30.

10. Display employees whose department_id is not 50.

11.Display employees whose job_id is not 'SA_REP'.

12.Display employees whose first_name starts with ‘A’.

13.Display employees whose last_name ends with ‘n’.

14. Display employees whose first_name contains the letter ‘e’.

15.Display employees whose manager_id is null.

16.Display employees whose commission_pct is not null.

17.Display employees who have job_id = 'SA_MAN' and salary greater then 10000.

18.Display employees who have department_id is 60 or job_id is 'IT_PROG'.

19. Display employees whose department_id is between 40 and 100.

20.Display employees who do not have any commission_pct assigned.