# select temat from tematy where NR_TEM = 1;
# select nazwisko from pracownicy where nazwisko like 'K%';
# select temat from tematy, pracownicy where nazwisko = 'MISIURA';
# select data_wypl from wyplaty, pracownicy where data_ur < '1970-01-01' and plec = 'K';
# select distinct kod_funkcji from pracownicy, tematy, przydzialy where nazwisko = 'MISIURA';
# select distinct nazwisko from pracownicy, tematy where (temat = 'GUPTA' or temat = 'DYSK') and plec = 'M' order by nazwisko desc;
# select distinct nazwa_funkcji from pracownicy, tematy, przydzialy, funkcje where (data_rozp < '1990-01-01' and data_odb < '1990-01-01');
# select p.temat, t.temat from tematy t, tematy p where t.NR_TEM = p.nr_tem_nadrz;
# select count (*) from tematy, pracownicy where NAZWISKO = 'MISIURA';
# select sum(KWOTA) from wyplaty, pracownicy, tematy where temat = 'DYSK';
# select avg(kwota) from wyplaty w, pracownicy p, tematy t where t.nr_prac_kt = p.nr_prac;
# select temat, kwo from (select nr_tem, sum(kwota) as kwo from wyplaty group by nr_tem) w, tematy t where t.NR_TEM = w.nr_tem;
# select nazwisko, avg(kwota) from pracownicy p, wyplaty w where w.NR_PRAC = p.nr_prac group by nazwisko;
# select min(data_ur) from pracownicy pra, przydzialy przy where pra.nr_prac = przy.nr_prac group by kod_funkcji;
# select temat, count(*) from tematy t, przydzialy p, funkcje f where f.KOD_FUNKCJI = p.KOD_FUNKCJI and t.NR_TEM = p.NR_TEM and f.nazwa_funkcji = 'Tester' group by temat;
# select temat, kwo from (select nr_tem, sum(kwota) as kwo from wyplaty group by nr_tem) w, tematy t where t.NR_TEM = w.nr_tem and kwo < 400;
# select nazwisko, num from pracownicy ppp, (select pra.NR_PRAC, count(*) as num from tematy t, pracownicy pra, przydzialy przy where przy.nr_prac = pra.nr_prac and przy.NR_TEM = t.nr_tem group by pra.NR_PRAC) www where www.nr_prac = ppp.nr_prac and num > 5;
# select temat, data_rozp from tematy t where t.data_rozp < (select data_rozp from tematy y where temat = 'DYSK');
{"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"}