First meeting: 
Solving Lab1 exercises 


Question 1:
select * 
from departments 

Question 2:
select last_name
from employees  
where department_id = 100

Question 3:
select department_id, last_name, salary 
from employees  
where department_id = 110 and salary > 3500

Question 4:
select department_id, last_name, salary 
from employees  
where department_id = 110 or salary > 3500

Question 5:
select last_name, salary
from employees 
where salary not between 5000 and 12000

Question 6:
select first_name, last_name
from employees 
order by first_name asc 

Question 7:
select first_name, last_name
from employees 
order by first_name desc

Question 8:
select first_name, last_name, department_id, salary
from employees 
order by department_id asc, salary desc

Question 9:
select last_name "Employees"
from employees 

Question 10:
select first_name, last_name
from employees 
where upper(last_name) like 'A%'

Question 11:
select last_name, manager_id
from employees 
where upper(first_name) like '%S' and manager_id = 204

Question 12:
select last_name, salary, salary*10000
from employees 

Question 13:
select last_name "Name", salary*10000 "Salary In TL", job_id
from employees 
where upper(job_id) = 'IT_PROG'

Question 14:
select first_name, last_name, salary
from employees 
where hire_date > '01-JAN-2006'

Question 15:
select first_name, last_name, hire_date
from employees 
where hire_date between '01-JAN-2005' and '31-DEC-2005'

Question 16:
select last_name, department_id
from employees 
where department_id IN (20,50) 
order by last_name asc

Question 17:
select last_name, salary, department_id
from employees 
where salary between 5000 and 12000 AND department_id IN (20,50) 

Question 18:
select last_name, hire_date 
from employees 
where hire_date between '01-JAN-2014' and '01-JAN-2014'

Question 19:
select last_name, job_id
from employees 
where manager_id is null

Question 20:
select last_name, job_id
from employees 
where manager_id is not null

Question 21:
select last_name, salary, commission_pct
from employees 
where sommission_pct is not null
order by salary desc, commission_pct desc 

Question 22:
select avg(salary)
from employees 

Question 23:
select min(salary)
from employees 

Question 24:
select sum(salary)
from employees