I am having issue on sorting column based on combination. We can sort on visualization on front end but the change is temporary . I am using a derived table to obtain results but when ever I use order by in my derived it gets overwritten by the view ...

How do I calculate the average over some values defined in a row ? For example H1 H2 ValueAx || a1 || 1 Ay || a1 || 2Az || a1 || 2 Ab || a2 || 2Ac || a2 || 3I need average for a1 that would be ( 1+2+2)/ 3 ( as there are three a1) . The hierarchal int...