select b.b_naziv, godina,
(select count(distinct s.smetka_br) from smetki as s
where b.banka_id=s.banka_id) as vkupen_broj_smetki,
(select count(distinct tr.trans_br || '-' || tr.smetka_br)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=1
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as br_trans_trim_1,
 (select count(distinct tr.trans_br || '-' || tr.smetka_br)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=2
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as br_trans_trim_2,
 (select count(distinct tr.trans_br || '-' || tr.smetka_br)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=3
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as br_trans_trim_3,
(select count(distinct tr.trans_br || '-' || tr.smetka_br)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=4
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as br_trans_trim_4,
(select sum(tr.iznos)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=1
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as  suma_iznos_trim_1,
(select sum(tr.iznos)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=2
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as suma_iznos_trim_2,
(select sum(tr.iznos)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=3
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as suma_iznos_trim_3,
(select sum(tr.iznos)
from smetki as s
join transakcii as tr
on s.smetka_br=tr.smetka_br
where (extract (quarter from tr.datum)=4
      and extract(year from tr.datum)=godini.godina )
      and s.banka_id=b.banka_id) as suma_iznos_trim_4

from banki as b,

(select distinct extract(year from tr.datum) godina
 from transakcii as tr) godini