12345678910111213141516171819202122232425262728 |
- --电费单价(新)使用局站级的电费预提明细
- --(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
|