SELECT cid , concat(max_peak_uv,'.000') from ( SELECT cid , max_peak_uv,ROW_NUMBER() over(PARTITION by cid order by max_peak_uv desc) as rk from ( SELECT cid , start_time , end_time,sum(if(是否进入 = '已进入',1,0)) as max_peak_uv from ( SELECT play_record_tb.uid , play_record_tb.cid , play_record_tb.start_...