| 1234567891011121314 |
- --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'
|
