chengben/Scripts/report/报表_6_超高能耗.sql

--6 ³¬¸ßÄܺÄÕ¾µã
select distinct
city_sname as city_name,
station_sname as jz_name,
station_type as jz_type,
station_level as cj,
property_type as qs_type,
meter_type_name as gd_type,
accrued_power as dy_dl,
eprice as df_dj,
accrued_cost as dy_df,
cost_unit_name as cb_zx,
lilun_power as dldb_dl,
over_lilun_power as dldb_fd,
lilun_eprice as dfdb_dj,
lilun_cost as dfdb_df,
over_lilun_cost as dfdb_fd,
city_code as city_id,
smonth as month_id,
grid_code as county_id,
area_name as county_name,
sort_id_city
from sqmdb_cost.rpt_baobiao_6_cgnh
where smonth='202205'
order by sort_id_city