题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
with t1 as(select room_id,count(distinct user_id) as user_count from user_view_tb where '24:00:00'>=out_time and out_time>='23:00:00' group by room_id) select a.room_id,b.room_name,a.user_count from t1 a join room_info_tb b on a.room_id=b.room_id order by a.user_count desc
管你几点进的，只要晚上11-12之间立刻就算在线。