淘天集团数开岗面试SQL题目:有表包含字段用户id、直播间id、进入直播间时间、离开直播间时间,统计直播间最高在线人数表room:用户uid:uid,直播间id:room_id,进入直播间时间:entry_time,离开直播间时间:leave_timeselect max(users) as max_usersfrom (select sum(nums) over(order by entry_time) as usersfrom ( select uid, room_id, entry_time, 1 as nums from room union all select u...