chengben/Scripts/bigscreen/chengben_other_3_b10.sql

--13、单端口能耗成本（月）
---北10
---chengben_other_3_b10_202203.csv
select 
smonth,
sname,
cost_nenghao,
port_inuse as ftth_port_count,
cost_port_nenghao,
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.rpt_dport_cost_b10
where smonth='202204'