123456789101112131415161718192021222324252627282930313233 |
- --03、网运成本预算完成进度(集团口径)
- ---北10(顺序:北京 天津 河北 山西 内蒙古 辽宁 吉林 黑龙江 山东 河南)
- select smonth,sname,
- column1 as total_cost,
- column2 as total_ys,
- case when column2=0 then 1 else column1/column2 end as rate_ys
- --case
- --when sname='北京' then 110000
- --when sname='天津' then 120000
- --when sname='河北' then 130000
- --when sname='山西' then 140000
- --when sname='内蒙古' then 150000
- --when sname='辽宁' then 210000
- --when sname='吉林' then 220000
- --when sname='黑龙江' then 230000
- --when sname='山东' then 370000
- --when sname='河南' then 410000
- --end as prov_code
- from sqmdb_cost.report50002
- where sname in('北京','天津','河北','山西','内蒙古','辽宁','吉林','黑龙江','山东','河南')
- and smonth='202203'
- order by case
- when sname='北京' then 1
- when sname='天津' then 2
- when sname='河北' then 3
- when sname='山西' then 4
- when sname='内蒙古' then 5
- when sname='辽宁' then 6
- when sname='吉林' then 7
- when sname='黑龙江' then 8
- when sname='山东' then 9
- when sname='河南' then 10
- end
|