chengben/Scripts/bigscreen/chengben_exception_3_grid.sql

--局站能耗
--（chengben_exception_3_grid_202203.csv）
select 
distinct
t1.smonth,
dg.city_code*100 as city_code,
dg.area_code,
t2.station_sid,
t2.station_name,
t1.nh_total,
t2.accrued_power,
t2.cost_unit_name
from sqmdb_cost.v_station_omc_nh t1--专业网管能耗
join
(select yn.smonth,yn.city_name,yn.area_name,sn.station_sid,station_name,yn.accrued_cost,yn.accrued_power,yn.cost_unit_name from sqmdb_cost.ytmx_new yn
join sqmdb_cost.station_nenghao sn on yn.build_code_short=sn.nh_sid_short) t2 --能耗表能耗
on t1.smonth=t2.smonth and t1.station_sid=t2.station_sid
left join sqmdb_cost.dict_grid dg on t2.city_name=dg.city_name and t2.area_name=dg.area_name
where t1.smonth='202204'