chengben/Scripts/bigscreen/chengben_other_4_b10.sql

--16、单站铁塔租赁费（月）
---北10数据（select * from sqmdb_cost.report50016）
---chengben_other_4_b10_202203.csv
select smonth,sname,column1 as tower_cost_avg_b10,
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.report50016
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