select k.k_ime, k.k_embg,
godina,

(
  select count(distinct t.trans_br || '-' || t.smetka_br)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=1 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as br_trans_trim_1,

(
  select count(distinct t.trans_br || '-' || t.smetka_br)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=2 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as br_trans_trim_2,

(
  select count(distinct t.trans_br || '-' || t.smetka_br)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=3 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as br_trans_trim_3,

(
  select count(distinct t.trans_br || '-' || t.smetka_br)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=4 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as br_trans_trim_4,

(
  select avg(t.iznos)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=1 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as prosek_iznos_trim_1,

(
  select avg(t.iznos)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=2 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as prosek_iznos_trim_2,

(
  select avg(t.iznos)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=3 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as prosek_iznos_trim_3,

(
  select avg(t.iznos)
  from transakcii t
  left join smetki s on t.smetka_br = s.smetka_br
  where extract(quarter from t.datum)=4 and
  extract(year from t.datum)=godina and
  s.klient_id = k.klient_id
) as prosek_iznos_trim_4

from klienti k,
(select distinct extract(year from t.datum) godina
from transakcii t) godini