chengben/Scripts/bigscreen/chengben_self_1_b10.sql

--预算进度
--chengben_self_1_b10_202203.csv
--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='202204'
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