chengben/Scripts/bigscreen/chengben_other_3_grid.sql

---Íř¸ń
---chengben_other_3_grid_202203.csv
select 
smonth,
city_sname as city_name,
grid_name as area_name,
cost_nenghao,
ftth_port_count,
cost_port_nenghao,
city_code*100 as city_code,
area_code
from sqmdb_cost.rpt_dport_cost_grid
where smonth='202204'
order by city_code,area_code