8/17/2019 3G PAGING.txt

1/1

SELECTDATE_ID,HOUR_ID,RNC,UTRANCELL,100 * ISNULL((convert(float,(SUM(pmNoPagingType1Attempt)) - convert(float,SUM(pmNoPagingAttemptUtranRejected)))/NULLIF(convert(float,SUM(pmNoPagingType1Attempt)

), 0)), 0) ASPaging_Succ_Rate,100 * ISNULL((100 * Z.pmNoPagingAttemptUtranRejected / nullif (Z.pmNoPagingType1Attempt,0) asnPaging_congSUM(pmNoPagingType1Attempt) as pmNoPagingType1Attempt_,SUM(pmNoPagingAttemptUtranRejected) as pmNoPagingAttemptUtranRejected_ FROM DC_E_RAN_UCELL_RAWWHERE RNC IN ('RNPWK03','RNPWK02','RNCMH01','RNBDG07','RNBKS04','RNBGR03','RNSKB02') AND DATE_ID>='2014-12-04'GROUP BYDATE_ID,

HOUR_ID,RNC,UTRANCELLORDER BYDATE_ID,HOUR_ID,RNC,UTRANCELL