| 123456789101112131415161718 |
- --14、单载频载扇能耗（月）
- ---北10
- select
- smonth as MONTH_ID,
- '北10' as ZB_TYPE,
- sname as PROV_NAME,
- null as CITY_ID,
- null as CITY_NAME,
- null as GRID_ID,
- null as GRID_NAME,
- '14' as ZB_CODE,
- '单载频载扇能耗（月）' as ZB_NAME,
- '否' as IS_RATIO,
- cost_yw+cost_hexin as QZ_FZ,
- zps_num_no5g as QZ_FM,
- case when zps_num_no5g=0 then 0 else (cost_yw+cost_hexin)/zps_num_no5g/6 end as BY_QZ
- from sqmdb_cost.rpt_dzpzs_cost_b10
- where smonth='202206'
|
