chengben/Scripts/kpi31/29_b10.sql

--29、单公里承载用户数
---北10
select 
smonth as MONTH_ID,
'北10' as ZB_TYPE,
sname as PROV_NAME,
null as CITY_ID,
null as CITY_NAME,
null as GRID_ID,
null as GRID_NAME,
'29' as ZB_CODE,
'单公里承载用户数' as ZB_NAME,
'否' as IS_RATIO,
total_user_yw+total_user_kd as QZ_FZ,
total_gl as QZ_FM,
round((total_user_yw+total_user_kd)/total_gl) as BY_QZ
from sqmdb_cost.jt_number_b10
where smonth='202206'