select
distinct bb.b_naziv,
gg.g_naziv,
(select count(distinct s.smetka_br)
from smetki as s
join klienti as k
on k.klient_id=s.klient_id
where (bb.banka_id=s.banka_id
and k.grad_id=gg.grad_id)) broj_smetki,
coalesce((select count(distinct tr.smetka_br || '-' || tr.trans_br)
from transakcii as tr
 join smetki as s
 on s.smetka_br=tr.smetka_br
join klienti as k
on k.klient_id=s.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
    and extract(quarter from tr.datum)=1)
),0) br_trans_trom_1,
coalesce((select count(distinct tr.smetka_br || '-' || tr.trans_br)
from transakcii as tr
 join smetki as s
 on s.smetka_br=tr.smetka_br
join klienti as k
on k.klient_id=s.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=2)
),0) br_trans_trom_2,
coalesce((select count(distinct tr.smetka_br || '-' || tr.trans_br)
from transakcii as tr
 join smetki as s
 on s.smetka_br=tr.smetka_br
join klienti as k
on k.klient_id=s.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=3)
),0)br_trans_trom_3,
coalesce((select count(distinct tr.smetka_br || '-' || tr.trans_br)
from transakcii as tr
 join smetki as s
 on s.smetka_br=tr.smetka_br
join klienti as k
on k.klient_id=s.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=4)
),0) br_trans_trom_4,
(select sum(tr.iznos)
from transakcii as tr
 join smetki as s
 on tr.smetka_br=s.smetka_br
join klienti as k
on s.klient_id=k.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=1)
) suma_iznos_trom_1,
(select sum(tr.iznos)
from transakcii as tr
 join smetki as s
 on tr.smetka_br=s.smetka_br
join klienti as k
on s.klient_id=k.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=2)
) suma_iznos_trom_2,
(select sum(tr.iznos)
from transakcii as tr
 join smetki as s
 on tr.smetka_br=s.smetka_br
join klienti as k
on s.klient_id=k.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=3)
)suma_iznos_trom_3,
(select sum(tr.iznos)
from transakcii as tr
 join smetki as s
 on tr.smetka_br=s.smetka_br
join klienti as k
on s.klient_id=k.klient_id
 where (bb.banka_id=s.banka_id
 and gg.grad_id=k.grad_id
       and extract(quarter from tr.datum)=4)
)suma_iznos_trom_4
from banki as bb,
(
select g.grad_id ,g.g_naziv from gradovi as g
  join banki as b
  on b.grad_id=g.grad_id
  join klienti as k
  on k.grad_id=g.grad_id
  join smetki as s
  on s.klient_id=k.klient_id
) as gg
group by bb.banka_id,gg.grad_id,gg.g_naziv