AdvancedReports: vkupenbrojnaracki.txt

create view vkupen_broj_naracki as 

select d.korisnicko_ime,n.korisnicko_ime,n.email,count(dost.id_dostavuvanja) as broj_naracki
from dostavuvaci as d
join korisnici as n on d.korisnicko_ime=n.korisnicko_ime
join dostavuvanja as dost on d.korisnicko_ime=dost.korisnicko_ime


group by 1, 2, 3;

select vbn.korisnicko_ime,vbn.email, vbn.broj_naracki as first
from vkupen_broj_naracki as vbn
where vbn.broj_naracki = (select max(broj_naracki) from vkupen_broj_naracki);