chengben/Scripts/数据校验/check_01_nenghao.sql

--能耗--输出报表
select 
smonth as 月份,
build_code_short as 能耗系统_局站短ID,
city_name as 能耗系统_地市,
area_name as 能耗系统_区县,
build_name as 能耗系统_局站名称,
accrued_power as 能耗系统_电量,
accrued_cost as 能耗系统_成本,
idx_city_name as 索引表_地市,
idx_nh_short_id as 索引表_局站短ID,
idx_station_sid as 索引表_局站ID,
idx_station_name as 索引表_局站名称,
omc_station_sid as 网管能耗_局站ID,
omc_nh_total as 网管能耗,
stype as 问题分类
from sqmdb_cost.err_has_nh_no_station 
order by sort_id_city