SUM of metric for normalized logical hierarchy
- by Alex254
Suppose there's a following table Table1, describing parent-child relationship and metric:
Parent | Child | Metric (of a child)
------------------------------------
name0 | name1 | a
name0 | name2 | b
name1 | name3 | c
name2 | name4 | d
name2 | name5 | e
name3 | name6 | f
Characteristics:
1) Child always has 1 and only 1 parent;
2)…