12345678910111213141516 |
- --13、单端口能耗成本(月)
- ---地市
- ---chengben_other_3_city_202203.csv
- select
- c.smonth,
- dg.city_name,
- c.cost_nenghao,
- c.port_inuse as ftth_port_count,
- c.cost_port_nenghao,
- dg.city_code*100 as city_code
- from sqmdb_cost.rpt_dport_cost_city c
- join
- (select distinct city_code,city_sname,city_name from sqmdb_cost.dict_grid) dg
- on c.city_sname=dg.city_sname
- where smonth='202204'
- order by dg.city_code
|