chengben/Scripts/report/报表_1_载频能耗.sql

--1 单载频载扇能耗
---网格报表
select
city_name as city_name,
grid_name as wg_name,
cost_grid as wg_dzpz_nh,
cost_city as bd_dzpz_nh,
cost_over_city as bd_dwfd,
rn_city as bd_pm,
cost_prov as qs_dzpz_nh,
cost_over_prov as qs_fd,
rn_prov as qs_pm,
city_code as city_id,
smonth as month_id
from sqmdb_cost.rpt_baobiao_1_dzpz
where smonth='202205'
order by sort_id_city,rn_city