题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
SELECT
r.room_id,
r.room_name,
COUNT(DISTINCT u.user_id) AS online_users
FROM user_view_tb u
LEFT JOIN room_info_tb r
ON u.room_id = r.room_id
WHERE u.in_time <= '24:00:00'
AND u.out_time >= '23:00:00'
GROUP BY r.room_id,r.room_name
ORDER BY online_users DESC;
荣耀工作强度 119人发布
投递荣耀等公司10个岗位 >