| 12345678910111213141516171819 |
- --14、单载频载扇能耗（月）
- ---地市
- select
- smonth as MONTH_ID,
- '地市' as ZB_TYPE,
- '河北' as PROV_NAME,
- city_code as CITY_ID,
- city_sname 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_with5g as QZ_FM,
- case when zps_num_with5g=0 then 0 else (cost_yw+cost_hexin)/zps_num_with5g/6 end as BY_QZ
- from sqmdb_cost.rpt_dzpzs_cost_city
- where smonth='202206'
- order by city_code
|
