--1
SELECT FIRST_NAME || ' ' || LAST_NAME AS OSOBA, salary AS PENSJA FROM employees
--2
SELECT FIRST_NAME, LAST_NAME FROM employees WHERE department_id = 100
--3
SELECT FIRST_NAME, LAST_NAME FROM employees WHERE job_id NOT IN ('IT_PROG')
--4
SELECT SYSDATE FROM dual
--5
SELECT FIRST_NAME, LAST_NAME, hire_date FROM employees
--6
SELECT FIRST_NAME, LAST_NAME, hire_date FROM employees WHERE TO_CHAR(hire_date, 'yyyy') > 2005 ORDER BY hire_date
--7
SELECT FIRST_NAME, LAST_NAME, hire_date FROM employees WHERE TO_CHAR(hire_date, 'yyyy') = 2007
--8
SELECT * FROM employees WHERE salary BETWEEN 6000 AND 8000
--9
SELECT department_id FROM employees WHERE MANAGER_ID IS NULL
--10
SELECT * FROM employees ORDER BY salary DESC
--11
SELECT * FROM employees WHERE department_id = 60 ORDER BY salary DESC
--12
SELECT * FROM employees WHERE department_id IN ('50','60','100')
--13
SELECT * FROM employees WHERE department_id IN ('70','80','110') AND SALARY  NOT BETWEEN 5000 AND 9000 ORDER BY salary
--14
SELECT FIRST_NAME, LAST_NAME, hire_date, salary FROM employees WHERE job_id = 'ST_CLERK' AND TO_CHAR(hire_date, 'yyyy') NOT BETWEEN 2004 AND 2005
--15
SELECT * FROM employees WHERE manager_id IS NULL
--16
SELECT DISTINCT first_name FROM employees ORDER BY first_name
--17
SELECT department_name FROM departments WHERE department_id NOT LIKE '\_\_0%'
--18
SELECT * FROM employees WHERE email LIKE '%G' AND department_id IN (90,110)
--19
SELECT department_id FROM departments WHERE location_id NOT IN (1700)
--20
SELECT first_name FROM employees WHERE first_name LIKE 'A%' OR first_name LIKE 'K%' ORDER BY first_name
--21
SELECT first_name, last_name, salary*1.2 FROM employees WHERE department_id IN (50,60,80)
--22
SELECT * FROM locations WHERE postal_code IS NULL
--23
SELECT department_id FROM departments WHERE location_id > 2000
--24
SELECT * FROM locations WHERE city NOT LIKE 'T%' OR city NOT LIKE 'B%'
--25
SELECT min_salary, max_salary, job_title FROM jobs
--26
SELECT min_salary*1.1, max_salary, job_title FROM jobs ORDER BY min_salary
--27
SELECT job_title, max_salary - min_salary AS ROZNICA FROM jobs ORDER BY roznica
--28
SELECT DISTINCT location_id FROM departments
--29
SELECT state_province FROM locations ORDER BY state_province
--30
SELECT min_salary, max_salary FROM jobs WHERE job_title LIKE 'Sale%'