SELECT nazivrs FROM radni_status;

SELECT DISTINCT sifraodelj FROM zaposleni;

SELECT ime, prezime, datrodj FROM zaposleni WHERE pol = 'Z';

SELECT ime, prezime, datrodj FROM zaposleni WHERE pol = 'Z' AND sifraodelj = 30;

SELECT sifraodelj, nazivodelj FROM odeljenje WHERE grad = 'Nis' OR grad = 'Novi Sad';

SELECT sifraodelj, nazivodelj FROM odeljenje WHERE NOT grad = 'Beograd';

SELECT ime, prezime FROM zaposleni WHERE plata >= 30000 AND plata <= 50000;

SELECT ime, prezime FROM zaposleni WHERE plata BETWEEN 30000 AND 50000;

SELECT ime, prezime, mlb, datrodj FROM zaposleni WHERE sifraodelj = 10 AND prezime LIKE 'M%';

SELECT ime, prezime, premija FROM zaposleni WHERE premija IS NOT NULL;

SELECT ime, prezime, premija FROM zaposleni WHERE premija IS NULL;

SELECT ime, prezime, plata FROM zaposleni WHERE sifraodelj = 40 ORDER BY plata ASC, premija DESC;

UPDATE radno_mesto SET nazivrm = 'Dizajner' WHERE sifraprof = (SELECT sifraprof FROM obrazovni_profil WHERE nazivprof = 'Srednja SS');

ROLLBACK;

UPDATE zaposleni SET plata = plata + 5000 WHERE sifrarukov = (SELECT sifrazap FROM zaposleni WHERE ime = 'Janko' AND prezime = 'Jankovic');

ROLLBACK;

SELECT prezime, LENGTH(prezime), instr(prezime, 'a') FROM zaposleni;

SELECT ime, substr(ime, 1, 3), prezime, concat(ime, prezime), TRIM(TRAILING 'c' FROM prezime) FROM zaposleni;

SELECT prezime, round((sysdate - datzap) / 7, 2) FROM zaposleni WHERE sifraodelj = 10;

SELECT prezime, datzap, round(months_between(sysdate, datzap), 2), add_months(datzap, 6), next_day(datzap, 'FRIDAY'), last_day(datzap) FROM zaposleni
WHERE months_between(sysdate, datzap) / 12 < 12;

SELECT ime, prezime, sifraodelj FROM zaposleni WHERE EXTRACT(YEAR FROM sysdate) - 10 = EXTRACT(YEAR FROM datzap);

SELECT sifrazap, ime, prezime, datzap FROM zaposleni WHERE datzap + INTERVAL '12' YEAR < sysdate;

SELECT * FROM angazovanje WHERE datod + INTERVAL '14-6' YEAR TO MONTH > sysdate;

SELECT prezime, plata, CASE sifraodelj
WHEN 10 THEN plata * 1.1
WHEN 20 THEN plata * 1.2
WHEN 30 THEN plata * 1.3
ELSE plata END
FROM zaposleni;