select p.kvartal,p.datum,g.naziv,pr.naziv,p.iznos from promet as p
inner join grad as g on g.id=p.grad_id
inner join prodavac as pr on pr.id=p.prodavac_id
group by p.datum,p.kvartal,g.grad_id,pr.prodavac_id