12345678910111213141516171819202122232425262728293031 |
- --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
|