题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select uv.room_id,room_name,count(distinct uv.user_id) user_count from user_view_tb uv join room_info_tb rt on uv.room_id=rt.room_id where left(in_time,2)=23 or (left(in_time,2)<23 and left(out_time,2)=23) group by uv.room_id,room_name order by user_count desc
人要去重
投递腾讯云智研发等公司7个岗位