select r.nrsversionid, c.tpsigeoregionid, r.name, c.tpsigeoregionareaseq, sum(c.areas) areas, sum(c.edges) edges from (
  select nrsversionid, tpsigeoregionid, tpsigeoregionareaseq, 1 areas, count(*) edges 
  from tpsigeoregionareapolygon
  group by nrsversionid, tpsigeoregionid, tpsigeoregionareaseq
  union select nrsversionid, tpsigeoregionid, NULL tpsigeoregionareaseq, NULL areas, count(*) edges 
  from tpsigeoregionareapolygon
  group by nrsversionid, tpsigeoregionid
  union select nrsversionid, tpsigeoregionid, NULL tpsigeoregionseq, count(*) areas, NULL edges
  from tpsigeoregionarea
  group by nrsversionid, tpsigeoregionid
) c
join tpsigeoregion r on r.nrsversionid = c.nrsversionid and r.id = c.tpsigeoregionid
group by r.nrsversionid, c.tpsigeoregionid, r.name, c.tpsigeoregionareaseq
order by edges desc, r.nrsversionid, nvl(c.tpsigeoregionid, -1), nvl(c.tpsigeoregionareaseq, -1);