The following is an example of an Ericsson 4G LTE Query for finding the CQI=Carrier Quality Index from performance parameter pmRadioUeRepCqiDistr by method of Weighted Average. SELECT Date_ID,HOUR_ID,ERBS,EUTRANCELLFDD, cast((SUM(A_0)+SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)) as float) as TS, cast((SUM(A_0) * 0.5) + (SUM(A_1) * 1) + (SUM(A_2) * 2) + (SUM(A_3) * 3) + (SUM(A_4) * 4) + (SUM(A_5) * 5) + (SUM(A_6) * 6) + (SUM(A_7) * 7) + (SUM(A_8) * 8) + (SUM(A_9) * 9+ (SUM(A_10) * 10) + (SUM(A_11) * 11) + (SUM(A_12) * 12) + (SUM(A_13) * 13)) as float) as Wgtd ,cast((Wgtd/TS) as dec (19,3)) as Reported_CQI, SUM(A_0) as pm_0, SUM(A_1) as pm_1, SUM(A_2) as pm_2, SUM(A_3) as pm_3, SUM(A_4) as pm_4, SUM(A_5) as pm_5, SUM(A_6) as pm_6, SUM(A_7) as pm_7, SUM(A_8) as pm_8, SUM(A_9) as pm_9, SUM(A_10) as pm_10, SUM(A_11) as pm_11, SUM(A_12) as pm...