题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select r.room_id,r.room_name, count(distinct u.user_id) as user_count from user_view_tb u join room_info_tb r on u.room_id = r.room_id where u.in_time <= '23:59:59' and u.out_time >= '23:00:00' group by r.room_id,r.room_name order by user_count desc
竟然无需使用time函数
腾讯开奖356人在聊
查看27道真题和解析