text: /*
  
  Leetflex Banned Accounts Problem
  
  Description
  LeetCode Problem 1747.
  
  Table: LogInfo
  
  +-------------+----------+
  | Column Name | Type     |
  +-------------+----------+
  | account_id  | int      |
  | ip_address  | int      |
  | login       | datetime |
  | logout      | datetime |
  +-------------+----------+
  There is no primary key for this table, and it may contain duplicates.
  The table contains information about the login and logout dates of Leetflex accounts. It also contains the IP address from which the account logged in and out.
  It is guaranteed that the logout time is after the login time.
  Write an SQL query to find the account_id of the accounts that should be banned from Leetflex. An account should be banned if it was logged in at some moment from two different IP addresses.
  
  Return the result table in any order.
  
  The query result format is in the following example:
  
  LogInfo table:
  +------------+------------+---------------------+---------------------+
  | account_id | ip_address | login               | logout              |
  +------------+------------+---------------------+---------------------+
  | 1          | 1          | 2021-02-01 09:00:00 | 2021-02-01 09:30:00 |
  | 1          | 2          | 2021-02-01 08:00:00 | 2021-02-01 11:30:00 |
  | 2          | 6          | 2021-02-01 20:30:00 | 2021-02-01 22:00:00 |
  | 2          | 7          | 2021-02-02 20:30:00 | 2021-02-02 22:00:00 |
  | 3          | 9          | 2021-02-01 16:00:00 | 2021-02-01 16:59:59 |
  | 3          | 13         | 2021-02-01 17:00:00 | 2021-02-01 17:59:59 |
  | 4          | 10         | 2021-02-01 16:00:00 | 2021-02-01 17:00:00 |
  | 4          | 11         | 2021-02-01 17:00:00 | 2021-02-01 17:59:59 |
  +------------+------------+---------------------+---------------------+
  
  Result table:
  +------------+
  | account_id |
  +------------+
  | 1          |
  | 4          |
  +------------+
  Account ID 1 --> The account was active from "2021-02-01 09:00:00" to "2021-02-01 09:30:00" with two different IP addresses (1 and 2). It should be banned.
  Account ID 2 --> The account was active from two different addresses (6, 7) but in two different times.
  Account ID 3 --> The account was active from two different addresses (9, 13) on the same day but they do not intersect at any moment.
  Account ID 4 --> The account was active from "2021-02-01 17:00:00" to "2021-02-01 17:00:00" with two different IP addresses (10 and 11). It should be banned.
  
  */
  
  # V0
  # TODO : verify if logic is correct
  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
  where  (l1.login < l2.logout and l1.logout > l2.login)
  
  # V1
  # https://circlecoder.com/leetflex-banned-accounts/
  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
  where not (l1.login > l2.logout or l1.logout < l2.login)
  
  # V2
  # Time:  O(n^2)
  # Space: O(n)
  SELECT DISTINCT l1.account_id
  FROM   loginfo l1
         INNER JOIN loginfo l2
                 ON l1.account_id = l2.account_id
                    AND l1.ip_address != l2.ip_address
  WHERE  NOT (l1.login > l2.logout
              OR l1.logout < l2.login); 