select g.g_naziv grad, god.godina,
(
select count(distinct tr.trans_br||'-'||tr.smetka_br)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=1
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) br_trans_trim_1,
(
select count(distinct tr.trans_br||'-'||tr.smetka_br)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=2
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) br_trans_trim_2,
(
select count(distinct tr.trans_br||'-'||tr.smetka_br)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=3
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) br_trans_trim_3,
(
select count(distinct tr.trans_br||'-'||tr.smetka_br)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=4
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) br_trans_trim_4,
(
select sum(tr.iznos)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=1
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) suma_iznos_trim_1,
(
select sum(tr.iznos)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=2
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) suma_iznos_trim_2,
(
select sum(tr.iznos)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=3
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) suma_iznos_trim_3,
(
select sum(tr.iznos)
  from transakcii tr
  join smetki s on s.smetka_br=tr.smetka_br
  join klienti k on k.klient_id=s.klient_id
  where extract(quarter from tr.datum)=4
  and extract(year from tr.datum) = god.godina
  and k.grad_id=g.grad_id
) suma_iznos_trim_4
from gradovi g,
(select distinct extract(year from t.datum) godina from transakcii t) god