id level description netprice Parentnode hirerachynode
100 0 Total sum(offering1+offering2) Null 1000
100 1 offering1 sum(service1+service2) 1000 11
100 1 offering2 sum(service3+service4) 1000 12
100 2 service1 sum(deilvery1+delivery2) 11 40
100 2 service2 sum(deilvery3+delivery4) 11 41
100 2 service3 sum(deilvery5+delivery6) 12 42
100 2 service4 sum(deilvery7+delivery8) 12 43
100 3 delivery1 110 40
100 3 delivery2 120 40
100 3 delivery3 130 41
100 3 delivery4 140 41
100 3 delivery5 - 150 42
100 3 delivery6 160 42
100 3 delivery7 170 43
100 3 delivery8 180 43
I have this data and i need to achieve the above summing for level 0,1,and 2 please let me know how to write a query to achieve this requirement