select k.k_ime,k.k_embg,godina,
(select count(distinct tr.trans_br || '-' || tr.smetka_br )
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=1 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as br_trans_trim_1,
(select count(distinct tr.trans_br || '-' || tr.smetka_br )
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=2 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as br_trans_trim_2,
(select count(distinct tr.trans_br || '-' || tr.smetka_br )
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=3 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as br_trans_trim_3,
(select count(distinct tr.trans_br || '-' || tr.smetka_br )
from transakcii as tr
 join smetki as s  on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=4 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as br_trans_trim_4,
(select avg(tr.iznos)
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=1 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as prosek_iznos_trim_1,
(select avg(tr.iznos)
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=2 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as prosek_iznos_trim_2,
(select avg(tr.iznos)
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=3 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as prosek_iznos_trim_3,
(select avg(tr.iznos)
from transakcii as tr
 join smetki as s on s.smetka_br=tr.smetka_br
 where extract(quarter from tr.datum)=4 and
   extract(year from tr.datum)=god.godina
    and s.klient_id=k.klient_id
) as prosek_iznos_trim_4

from klienti as k,

(select distinct extract(year from t.datum) godina
from transakcii t) god