Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL_IND_03
- -SQL_IND03_02
- select s.br_smetka, (null)br_ovlasteni, (null) sum_transakcii, (null) prosek_transakcii, (null) br_odgovorni
- from smetki as s
- -SQL_IND03_03
- select count(id_klient_sopstvenik)
- from smetki s
- left join ovlasteni_lica o on o.id_klient=s.id_klient_sopstvenik
- where s.br_smetka = 5
- -SQL_IND03_O4
- select sum(t.iznos)
- from smetki s
- join transakcii t on s.br_smetka=t.br_smetka
- where s.br_smetka = 5
- -SQL_IND03_05
- select avg(transakcii.iznos)
- from transakcii,smetki
- where smetki.br_smetka=5
- and transakcii.br_smetka=smetki.br_smetka
- -SQL_IND03_06
- select count(distinct odgovoren.id_vraboten)
- from odgovoren
- where odgovoren.br_smetka=5
- -SQL_IND03_07
- select s.br_smetka,(select count(*) from ovlasteni_lica ol
- where s.br_smetka=ol.br_smetka)as BR_OVLASTENI,
- (select sum(t.iznos)from transakcii t where t.br_smetka=s.br_smetka)as SUM_TRANSAKCII,(select avg(t.iznos)from transakcii t where t.br_smetka=s.br_smetka)as PROSEK_TRANSAKCII,(select count(distinct o.id_vraboten)from odgovoren o where o.br_smetka=s.br_smetka) as BR_ODGOVORNI
- from smetki s
Add Comment
Please, Sign In to add comment