| 123456789101112131415161718192021222324 |
- --19、无线成本占收比
- ---北10
- select
- a.smonth as MONTH_ID,
- '北10' as ZB_TYPE,
- a.sname as PROV_NAME,
- null as CITY_ID,
- null as CITY_NAME,
- null as GRID_ID,
- null as GRID_NAME,
- '19' as ZB_CODE,
- '无线成本占收比' as ZB_NAME,
- '是' as IS_RATIO,
- a.cost_wireless as QZ_FZ,
- b.income_year as QZ_FM,
- case when b.income_year=0 then null else a.cost_wireless/b.income_year end as BY_QZ
- from
- (select '202206' as smonth,sname,stype,
- sum(column2+column3+column4+column5+column6+column7+column8+column9+column10+column11+column12+column13+column14+column15+column16+column17)/10000 as cost_wireless --column18 账面人工成本
- from sqmdb_cost.report50 where period_type='M' and smonth between '202201' and '202206' group by sname,stype) a
- left join
- (select report_id,smonth,sname,stype,column4 as income_year from sqmdb_cost.report80040 where smonth='202206') b
- on a.sname=b.sname
- where a.sname in('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')
|
