The following is an example of an Ericsson ENIQ SQL Query for finding the IUB Frame Loss Intensity by method of Weighted Average. SELECT Date_ID,Hour_ID,MIN_ID,RNC,RBS, SUM(A_0) as A_0,SUM(A_1) as A_1,SUM(A_2) as A_2,SUM(A_3) as A_3,SUM(A_4) as A_4,SUM(A_5) as A_5,SUM(A_6) as A_6,SUM(A_7) as A_7,SUM(A_8) as A_8,SUM(A_9) as A_9,SUM(A_10) as A_10,SUM(A_11) as A_11,SUM(A_12) as A_12,SUM(A_13) as A_13,SUM(A_14) as A_14,SUM(A_15) as A_15,(A_0 * 1) as B_0,(A_1 * 1.5) as B_1,(A_2 * 3.5) as B_2,(A_3 * 6.5) as B_3,(A_4 * 12.5) as B_4,(A_5 * 24.5) as B_5,(A_6 * 48.5) as B_6,(A_7 * 96.5) as B_7,(A_8 * 192.5) as B_8,(A_9 * 384.5) as B_9,(A_10 * 768.5) as B_10,(A_11 * 1536.5) as B_11,(A_12 * 3072.5) as B_12,(A_13 * 6144.5) as B_13,(A_14 * 12288.5) as B_14,(A_15 * 16385) as B_15, cast(100*((B_1+B_2+B_3+B_4+B_5+B_6+B_7+B_8+B_9+B_10+B_11+B_12+B_13+B_14+B_15)/(B_0+B_1+B_2+B_3+B_4+B_5+B_6+B_7+B_8+B_9+B_10+B_11+B_12+B_13+B_14+B_15)) as dec(19,5)) as C_1...