# $1747. 应该被禁止的Leetflex账户
# https://leetcode-cn.com/problems/leetflex-banned-accounts/

# SQL架构
Create table If Not Exists LogInfo (account_id int, ip_address int, login datetime, logout datetime);
Truncate table LogInfo;
insert into LogInfo (account_id, ip_address, login, logout) values ('1', '1', '2021-02-01 09:00:00', '2021-02-01 09:30:00');
insert into LogInfo (account_id, ip_address, login, logout) values ('1', '2', '2021-02-01 08:00:00', '2021-02-01 11:30:00');
insert into LogInfo (account_id, ip_address, login, logout) values ('2', '6', '2021-02-01 20:30:00', '2021-02-01 22:00:00');
insert into LogInfo (account_id, ip_address, login, logout) values ('2', '7', '2021-02-02 20:30:00', '2021-02-02 22:00:00');
insert into LogInfo (account_id, ip_address, login, logout) values ('3', '9', '2021-02-01 16:00:00', '2021-02-01 16:59:59');
insert into LogInfo (account_id, ip_address, login, logout) values ('3', '13', '2021-02-01 17:00:00', '2021-02-01 17:59:59');
insert into LogInfo (account_id, ip_address, login, logout) values ('4', '10', '2021-02-01 16:00:00', '2021-02-01 17:00:00');
insert into LogInfo (account_id, ip_address, login, logout) values ('4', '11', '2021-02-01 17:00:00', '2021-02-01 17:59:59');

# Write your MySQL query statement below
select
    distinct l1.account_id as account_id
from
    LogInfo l1,
    LogInfo l2
where
    l1.account_id = l2.account_id
    and l1.ip_address != l2.ip_address
    and l1.logout <= l2.logout
    and l1.logout >= l2.login;

# clean-up
drop table LogInfo;