Scribd
Upload
8 views2 pages

4G Traffic Data Analysis Query

The document contains a SQL query that selects data from multiple tables and joins them together. It selects various metrics like traffic, availability, EUT, PRB utilization and aggregates or formats the date. It joins data from 4g_combine_day_mocn and 4g_combine_hr_bh_mocn tables on different keys and filters for dates on or after 20220613. It also joins with another table List Eut_Final to retrieve neighbor/cluster related data.

Uploaded by

LMT NS XL JPS
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views2 pages

4G Traffic Data Analysis Query

The document contains a SQL query that selects data from multiple tables and joins them together. It selects various metrics like traffic, availability, EUT, PRB utilization and aggregates or formats the date. It joins data from 4g_combine_day_mocn and 4g_combine_hr_bh_mocn tables on different keys and filters for dates on or after 20220613. It also joins with another table List Eut_Final to retrieve neighbor/cluster related data.

Uploaded by

LMT NS XL JPS
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SELECT

CONCAT(b.SiteID_Neighbor,[Link],b.`I/N`) as ref,

[Link],

b.SiteID_Neighbor,

[Link],

a.total_traffic,

[Link],

[Link],

a.dl_prb,

[Link],

[Link],

concat([Link],"_",right(SUBSTRING_INDEX(SiteID_Neighbor,"_",-1),1)) as site_sector,

b.Cluster_Name,

b.`I/N`,

b.Action_Status,

b.Date_optim_cluster,

a.MC_H3I_EUT_Nom,

a.MC_H3I_EUT_Denom,

a.`MC_H3I_DL PRB Utilization_Nom`,

a.`MC_H3I_DL PRB Utilization_Denom`

FROM

(SELECT

[Link],

concat([Link],"_",[Link]) as `site_cellid`,[Link],a.total_traffic,[Link],

[Link],b.dl_prb,DATE_FORMAT([Link],"%b") as Bulan,DATE_FORMAT([Link],"%e") as
Tanggal,b.MC_H3I_EUT_Nom,b.MC_H3I_EUT_Denom,b.`MC_H3I_DL PRB
Utilization_Nom`,b.`MC_H3I_DL PRB Utilization_Denom`

from

4g_combine_day_mocn a
INNER JOIN 4g_combine_hr_bh_mocn b ON

[Link] = [Link] and a.mrbts_name = b.mrbts_name and a.bts_name = b.bts_name and a.lncel_name =
b.lncel_name

and [Link] = [Link] and [Link] = [Link] and [Link] = [Link] and [Link] = [Link]

and [Link] = [Link]

WHERE

[Link] >= 20220613) a

INNER JOIN `List Eut_Final` b on a.site_cellid = b.SiteID_Neighbor

You might also like