题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select
t1.room_id,
t1.room_name,
count(distinct t1.user_id) as user_count
from (
select
*
from user_view_tb as a
left join room_info_tb b using(room_id)
) t1
where t1.in_time <= '23:59:59' and t1.out_time >= '23:00:00'
group by t1.room_id,t1.room_name
order by user_count desc
联想公司福利 1477人发布
感觉非常棒了，过几天面试肯定多了，现在太早
投递北森等公司10个岗位