| 123456789101112131415161718 |
- --16、单站铁塔租赁费（月）
- ---网格
- 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,
- '16' as ZB_CODE,
- '单站铁塔租赁费（月）' as ZB_NAME,
- '否' as IS_RATIO,
- tower_cost as QZ_FZ,
- tower_num_avg as QZ_FM,
- tower_cost_avg as BY_QZ
- from sqmdb_cost.rpt_tower_cost_grid
- where smonth='202206'
|
