SQL Assignment 1

1.Select all columns from the EMPLOYEES table.

2. Retrieve the first and last names of all employees.

3.Show all employees whose salary greater then 4000 or less then 14000.

4.List employees whose salary is greater than 5000.

5.Find employees who work in department 90.

6.Display employees whose job_id is 'MAN'.

7. List employees without department .

8.Show employees with a commission percentage.

9.Get employees without a manager.

10. Retrieve employee names and salaries, PF 10% of salary, HRA 12% of Salary and Total Salary = Salary +HRA-PF.

11.Select the employees whose last name start with ‘L’.

12.Select job IDs from employees table.

13.Find the employees in department 50.

14.List employees with first names starting with 'A'.

15.Find employees whose names contain the letter 'e'.

16. Display employees having First Name start with ‘P’ and working in department 80.

17.Show the full name (first + last name) of each employee.

18.List employees where the salary is between 3000 and 6000.

19. Show the employee’s first name who receive a commission.

20. List employees who don’t receive a commission.