SELECT departament.nr_departamentu,departament.nazwa, pensja
FROM pracownik right join departament
WHERE departament.nr_departamentu = pracownik.nr_departamentu;
SELECT nazwa, nazwisko
FROM pracownik p full join zlecenie z right join projekt pr on pr.nr_projektu = z.nr_projektu on p.id_pracownika = z.id_pracownika
WHERE z.id_pracownika is NULL or z.nr_projektu is NULL;
SELECT stanowisko ,AVG(pensja + nvl(premia, 0)),MIN(pensja + nvl(premia, 0)), MAX(pensja + nvl(premia, 0))
FROM pracownik
GROUP BY stanowisko;
SELECT MIN(pensja + nvl(premia, 0)), MAX(pensja + nvl(premia, 0))
FROM pracownik;
SELECT count(id_pracownika)
FROM pracownik
WHERE upper(stanowisko) = 'ANALITYK';
SELECT d.nr_departamentu,nazwa, count(id_pracownika)
FROM pracownik p RIGHT JOIN departament d
ON p.nr_departamentu = d.nr_departamentu
GROUP BY nazwa,d.nr_departamentu;
SELECT nazwa, avg(pensja) as SREDNIA, lokalizacja, departament.nr_departamentu
FROM pracownik, departament
WHERE pracownik.nr_departamentu = departament.nr_departamentu
AND (LOWER(lokalizacja) = 'warszawa' or LOWER(lokalizacja) = 'bialystok'
GROUP BY nazwa, lokalizacja, departament.nr_departamentu
HAVING AVG(pensja)>1500;
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}