chengben/Scripts/bigscreen/chengben_other_2_grid.sql

---µ¥ÔØƵÔØÉÈÄܺÄ-Íø¸ñ
---chengben_other_2_grid_202203.csv
select 
grid.smonth,
grid.city_name,
grid.grid_name,
grid.cost_yw,
grid.cost_hexin,
grid.cost_total,
grid.zps_num_with5g,
null zps_num_no5g,
grid.cost_zps_with5g,
null cost_zps_no5g,
dg1.city_code*100 as city_code,
dg2.area_code
from sqmdb_cost.rpt_dzpzs_cost_grid grid
left join
(select distinct city_code,grid_city_name from sqmdb_cost.dict_grid) dg1
on grid.city_name=dg1.grid_city_name
left join
(select distinct city_code,area_code,grid_city_name,grid_name from sqmdb_cost.dict_grid) dg2
on grid.city_name=dg2.grid_city_name and grid.grid_name=dg2.grid_name
where smonth='202204'
order by dg1.city_code,dg2.area_code