题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
select c.room_id room_id,r.room_name room_name,c.abc user_count
from (
select room_id,count(distinct user_id) abc
from user_view_tb
where in_time<='23:59:59' and out_time>='23:00:00'
group by room_id
) c
left join room_info_tb r on c.room_id=r.room_id
投递快手等公司10个岗位
滴滴公司福利 638人发布