题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
select room_id, max(room_name), count(distinct user_id) as user_count from user_view_tb join room_info_tb using(room_id) where out_time>='23:00:00' group by room_id order by user_count desc
从0开始的SQL之旅 文章被收录于专栏
从0开始的SQL之旅
查看22道真题和解析