chengben/Scripts/bigscreen/chengben_exception_2_grid.sql

--电费单价（新）使用局站级的电费预提明细
--（chengben_exception_2_grid_202203.csv）
select 
yn.smonth,
yn.city_name,
yn.area_name,
s.station_sid,
s.station_sname,
yn.meter_type_name,
yn.accrued_cost,
yn.accrued_power,
case when accrued_power=0 then 0 else yn.accrued_cost/yn.accrued_power end as eprice,
yn.cost_unit_name,
dg1.city_code*100 as city_code,
dg2.area_code
from sqmdb_cost.ytmx_new yn
left join sqmdb_cost.station_nenghao sn on yn.build_code_short=sn.nh_sid_short
left join sqmdb_cost.station3 s on sn.station_sid=s.station_sid
left join (select distinct city_code,city_name from sqmdb_cost.dict_grid) dg1
on yn.city_name=dg1.city_name
left join 
(select distinct city_code,city_name,area_code,area_name from sqmdb_cost.dict_grid) dg2
on yn.city_name=dg2.city_name and yn.area_name=dg2.area_name
where yn.meter_type_name in ('12-01 | 转供手抄表','21-01 | 定额协议表','21-02 | 铁塔包干表')
and s.station_sid is not null
and (case when accrued_power=0 then 0 else yn.accrued_cost/yn.accrued_power end)>0.8
and yn.smonth='202204'
order by dg1.city_code,dg2.area_code