| 1234567891011121314151617181920 |
- --10、修理维护费占收比（省内口径）
- select
- cs.smonth as MONTH_ID,
- '北10' as ZB_TYPE,
- cs.sname as PROV_NAME,
- null as CITY_ID,
- null as CITY_NAME,
- null as GRID_ID,
- null as GRID_NAME,
- '10' as ZB_CODE,
- '修理维护费占收比（省内口径）' as ZB_NAME,
- '是' as IS_RATIO,
- cs.cost_fix as QZ_FZ,
- r.column4 as QZ_FM,
- cs.cost_fix/r.column4 as BY_QZ
- from sqmdb_cost.chengben_shengnei cs
- join sqmdb_cost.report80040 r on cs.smonth=r.smonth and cs.sname=r.sname
- where r.period_type='M'
- and cs.stype='北10'
- and cs.smonth='202206'
|
