题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select room_id,
room_name,
count(distinct user_id) as user_count
from (
select room_id,user_id
from user_view_tb
where in_time between '23:00:00' and '23:59:59'
or out_time between '23:00:00' and '23:59:59'
) a
join room_info_tb
using(room_id)
group by room_id,room_name
投递字节跳动等公司7个岗位