id1    id2    id2_sum  id_3  id_4  sum
7      1      200      1     1	   1
7      1      200      2     1	   2
7      1      200      3     1	   4
7      1      200      2     2	   3
7      2      300      2     1	   2
7      2      300      1     1	   1
7      2      300      2     2	   3
8      1      700      2     2	   3

id1 sum(id2_sum)  sum(sum)
7   500           16
8   700           3

with group_sums as(
    select id1, sum(id2_sum)/count(id2) as id2_sum, sum(sum) as sum
    from test
    group by id1, id2
)
select id1, sum(id2_sum), sum(sum)
from group_sums
group by id1