题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select
u.room_id,
r.room_name,
count(distinct u.user_id) as user_count
from
user_view_tb u left join room_info_tb r
on
u.room_id=r.room_id
where
u.out_time >='23:00:00'
and
u.in_time <='24:00:00'
group by
u.room_id,r.room_name
order by
count(distinct u.user_id) desc
