LeetCode（数据库）- 应该被禁止的Leetflex账户

-- 解决方案(1)
select distinct a.account_id
from loginfo a join loginfo b on a.account_id = b.account_id
where a.ip_address != b.ip_address and !(a.logout < b.login || b.logout < a.login)
-- 解决方案(2)
SELECT DISTINCT l1.account_id
FROM LogInfo l1 JOIN LogInfo l2 ON l1.account_id = l2.account_id AND l1.ip_address <> l2.ip_address 
AND (l1.login BETWEEN l2.login AND l2.logout OR l1.logout BETWEEN l2.login AND l2.logout)