15.
A select imie, nazwisko, pensja from 'pracownicy' order by pensja DESC
B select AVG pensja, imie, nazwisko, from 'pracownicy'
C select marka ,typ,data_produkcji from 'samochody' order by data_produkcji ASC
16.
A Select marka,typ,data_produckji from 'samochody' where wypozyczenia IS NULL
B select imie nazwisko from 'klient' where wypozyczenia is null and order by DESC
C select imie nazwisko from 'klient' where wypozyczenia is null
17.
A select imie,nazwisko from 'klient' group by wypozyczenia order by asc
B -
C -
18.
A select imie , nazwisko from 'klient' group by wypozyczenia having wypozyczenia >2 order by desc
B select marka , typ from 'samochody' group by wypozyczenia having wypozyczenia =2 order by DESC
C select imie,nazwisko from 'klient' group by wypozyczenia having wypozyczenia <2 order by DESC
19.
A select MAX id_samochodu,marka,typ from 'samochody' group by wypozyczenia order by desc
B select MIN id_klienta,imie,nazwisko from 'klient'group by wypozyczenia order by desc
C select MAX id_pracownika,nazwisko,imie from 'pracownicy' group by wypozyczenia order by desc
20.
A update pracownicy set pencja +50 where dodatek=0
B update klient set imie=Jerzy and nazwisko=Nowak where id_klient=10
C update pracownicy set pensja +10%pensja where pensja ASV
21.
A delete klient where id=17
B delete klient set wypozyczenia where id=17
C delete klient where wypozyczenia=0
22.
A insert into klient id_klient,imie,nazwisko,adres,kod_pocztowy,nr_tel VALUES(21,"Adam","Cichy","ul korzenna 12","00-950 warszawa" ,123-456-321
B insert into samochod id_samochodu,kolor,marka,poj_silnika,data_produkcji,przebieg VALUES (19,"srebrny","Skoda octavia",1896,1.09.2012,5000)
C -
{"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"}