AdvancedReports: vkupenbrojnaracki.txt
File vkupenbrojnaracki.txt, 480 bytes (added by , 18 months ago) |
---|
Line | |
---|---|
1 | create view vkupen_broj_naracki as |
2 | |
3 | select d.korisnicko_ime,n.korisnicko_ime,n.email,count(dost.id_dostavuvanja) as broj_naracki |
4 | from dostavuvaci as d |
5 | join korisnici as n on d.korisnicko_ime=n.korisnicko_ime |
6 | join dostavuvanja as dost on d.korisnicko_ime=dost.korisnicko_ime |
7 | |
8 | |
9 | group by 1, 2, 3; |
10 | |
11 | select vbn.korisnicko_ime,vbn.email, vbn.broj_naracki as first |
12 | from vkupen_broj_naracki as vbn |
13 | where vbn.broj_naracki = (select max(broj_naracki) from vkupen_broj_naracki); |