【資料名稱】：電平分布腳本

【資料作者】：china

【資料日期】：20110621

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

select
to_char(a.period_start_time, 'yyyymmdd') Repdate,
o.name BSC,
c.la_id_lac LAC,
c.cell_id CI,
a.class_upper_range RXLEV,
sum(a.freq_ul_qual0) uq0,
sum(a.freq_ul_qual1) uq1,
sum(a.freq_ul_qual2) uq2,
sum(a.freq_ul_qual3) uq3,
sum(a.freq_ul_qual4) uq4,
sum(a.freq_ul_qual5) uq5,
sum(a.freq_ul_qual6) uq6,
sum(a.freq_ul_qual7) uq7,
sum(a.freq_ul_qual6+a.freq_ul_qual7) slev_uq67_num,
sum(a.freq_ul_qual0+a.freq_ul_qual1+a.freq_ul_qual2+a.freq_ul_qual3+a.freq_ul_qual4+a.freq_ul_qual5+a.freq_ul_qual6+a.freq_ul_qual7) slev_uq07_num,
decode(sum(a.freq_ul_qual0+a.freq_ul_qual1+a.freq_ul_qual2+a.freq_ul_qual3+a.freq_ul_qual4+a.freq_ul_qual5+a.freq_ul_qual6+a.freq_ul_qual7),0,0,round(100*sum(a.freq_ul_qual6+a.freq_ul_qual7)/sum(a.freq_ul_qual0+a.freq_ul_qual1+a.freq_ul_qual2+a.freq_ul_qual3+a.freq_ul_qual4+a.freq_ul_qual5+a.freq_ul_qual6+a.freq_ul_qual7),2)) slev_ubadqual_rate,
sum(a.freq_dl_qual0) dq0,
sum(a.freq_dl_qual1) dq1,
sum(a.freq_dl_qual2) dq2,
sum(a.freq_dl_qual3) dq3,
sum(a.freq_dl_qual4) dq4,
sum(a.freq_dl_qual5) dq5,
sum(a.freq_dl_qual6) dq6,
sum(a.freq_dl_qual7) dq7,
sum(a.freq_dl_qual6+a.freq_dl_qual7) slev_dq67_num,
sum(a.freq_dl_qual0+a.freq_dl_qual1+a.freq_dl_qual2+a.freq_dl_qual3+a.freq_dl_qual4+a.freq_dl_qual5+a.freq_dl_qual6+a.freq_dl_qual7) slev_dq07_num,
decode(sum(a.freq_dl_qual0+a.freq_dl_qual1+a.freq_dl_qual2+a.freq_dl_qual3+a.freq_dl_qual4+a.freq_dl_qual5+a.freq_dl_qual6+a.freq_dl_qual7),0,0,round(100*sum(a.freq_dl_qual6+a.freq_dl_qual7)/sum(a.freq_dl_qual0+a.freq_dl_qual1+a.freq_dl_qual2+a.freq_dl_qual3+a.freq_dl_qual4+a.freq_dl_qual5+a.freq_dl_qual6+a.freq_dl_qual7),2)) slev_dbadqual_rate
from
p_nbsc_rx_statistics a, c_bts c, objects o
where
a.bts_int_id = c.int_id
and a.int_id = o.int_id
and c.conf_name = '<ACTUAL>'
--and a.class_upper_range in (30,40,73)
and o.name like 'XX%'
--and c.cell_id in ()
and to_char(a.period_start_time, 'yyyymmdd') between &Sdate and &Edate
group by a.period_start_time,o.name,c.la_id_lac,c.cell_id,a.class_upper_range
order by a.period_start_time,o.name,c.la_id_lac,c.cell_id