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