SQL Assignment 1

SQL ASSIGNMENT Part 1

Display all columns from the employees table.

code: desc employees;

Display the first_name and last_name of all employees.

code: select first_name, last_name from employees;

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

code: select employee_id, job_id, salary from employees;

Display employees whose salary is greater than 10000.

code: select employee_id, first_name, last_name, job_id, salary from employees where salary>=10000;

Display employees whose salary is less than 5000.

code: select employee_id, first_name, last_name, job_id, salary from employees where salary<=5000;

Display employees who belong to department_id = 90.

code: select employee_id, first_name, last_name, job_id, salary from employees where department_id=90;

Display employees who work as 'IT_PROG'.

code: select employee_id, first_name, last_name, job_id, salary from employees where job_id='IT_PROG';

Display employees whose salary is between 8000 and 12000.

code: select employee_id, first_name, last_name, job_id, salary from employees where salary between 8000 and 12000;

Display employees whose department_id is 10, 20, 30.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where department_id in (10, 20, 30);

Display employees whose department_id is not 50.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where department_id!=50;

Display employees whose job_id is not 'SA_REP'.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where job_id!='SA_REP';

Display employees whose first_name starts with ‘A’.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where first_name like 'A%';

Display employees whose last_name ends with ‘n’.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where last_name like '%n';

Display employees whose first_name contains the letter ‘e’.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where first_name like '%e%';

Display employees whose manager_id is null.

code: select employee_id, first_name, last_name, job_id, salary, department_id, manger_id from employees where manager_id is null;

Display employees whose commission_pct is not null.

code: select employee_id, first_name, last_name, job_id, salary, department_id, manger_id, comission_pct from employees commission_pct is not null;

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

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where job_id like 'SA_MAN';

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

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where department_id=60 or job_id like 'IT_PROG';

Display employees whose department_id is between 40 and 100.

code: select employee_id, first_name, last_name, job_id, salary, department_id from employees where department_id between 40 and 100.

Display employees who do not have any commission_pct assigned.

code: select employee_id, first_name, last_name, job_id, salary, department_id, comission_pct from employees where commission_pct is null.