--29、单公里承载用户数
--30、单载频载扇用户数
---地市
select 
month_id,
city_name,
total_user_yw,
total_user_kd,
total_gl,
zps_total_with5g,
round((total_user_yw+total_user_kd)/total_gl) as per_km_user,
round(total_user_yw/zps_total_with5g) as per_zps_user
from sqmdb_cost.jt_number_city jnc 
where month_id='202203'