chengben/Scripts/bigscreen/chengben_other_1_city_b10.sql

--02、网运成本占收比（省内口径）
--chengben_other_1_city_b10_202203.csv
select t1.*,
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
else t2.city_code*100 end as city_code 
from
(select smonth,stype,sname,cost_total,income,
cost_total/income as cost_income_rate
from sqmdb_cost.chengben_shengnei
--where stype='北10'
--where stype='地市'
where smonth='202204') t1
left join
(select distinct city_code,city_pro from sqmdb_cost.dict_grid) t2
on t1.sname=t2.city_pro