View difference between Paste ID: n0Y155rV and 913cnDpQ

 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