| 123456789101112131415161718 |
- --14、单载频载扇能耗（月）
- ---网格
- select
- smonth as MONTH_ID,
- '网格' as ZB_TYPE,
- '河北' as PROV_NAME,
- city_code*100 as CITY_ID,
- city_name as CITY_NAME,
- grid_code as GRID_ID,
- grid_name 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,
- cost_zps_with5g as BY_QZ
- from sqmdb_cost.rpt_dzpzs_cost_grid grid
- where smonth='202206'
|
