题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

SELECT DISTINCT uvt.room_id, room_name, COUNT(DISTINCT user_id) AS user_count
FROM user_view_tb uvt
LEFT JOIN room_info_tb rit ON uvt.room_id = rit.room_id
WHERE in_time BETWEEN '23:00:00' AND '24:00:00' OR in_time < '23:00:00' AND out_time >= '23:00:00'
GROUP BY uvt.room_id, room_name
ORDER BY user_count DESC;

注：如何判断时间是否在某区间内？和比较数值大小的语句一样。