题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select v.room_id, room_name, count(distinct user_id) user_count from user_view_tb v join room_info_tb r using(room_id) where in_time <= '24:00:00' and out_time >='23:00:00' group by v.room_id, room_name order by user_count desc； 时间范围比较重要
查看25道真题和解析
