题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
SELECT
rt.room_id,
rt.room_name,
COUNT(DISTINCT user_id) user_count
FROM user_view_tb ut
JOIN room_info_tb rt ON ut.room_id = rt.room_id
WHERE (SUBSTRING(ut.in_time,1,2) = 23 OR SUBSTRING(ut.out_time,1,2) = 23) OR
(SUBSTRING(ut.in_time,1,2) = 00 OR SUBSTRING(ut.out_time,1,2) = 00)
GROUP BY rt.room_id, rt.room_name
ORDER BY user_count DESC
滴滴公司福利 1784人发布
投递腾讯云智研发等公司7个岗位