| 123456789101112131415161718 |
- --13、单端口能耗成本（月）
- ---北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,
- '13' as ZB_CODE,
- '单端口能耗成本（月）' as ZB_NAME,
- '否' as IS_RATIO,
- cost_nenghao as QZ_FZ,
- port_inuse as QZ_FM,
- cost_nenghao/port_inuse/6 as BY_QZ
- from sqmdb_cost.rpt_dport_cost_b10
- where smonth='202206'
|
