SQL面试题——抖音SQL面试题 共同问题—共同使用ip用户检测问题

共同使用ip用户检测问题

现有用户登录日志表，记录了每个用户登录的IP地址，请查询共同使用过3个及以上IP的用户对；

+---+--------------+-------------------+
| id|            ip|              etime|
+---+--------------+-------------------+
|  2|223.104.41.101|2023-08-24 07:00:00|
|  4|223.104.41.122|2023-08-24 10:00:00|
|  5|223.104.41.126|2023-08-24 11:00:00|
|  4|223.104.41.126|2023-08-24 13:00:00|
|  1|223.104.41.101|2023-08-24 16:00:00|
|  3|223.104.41.101|2023-08-24 16:02:00|
|  2|223.104.41.104|2023-08-24 16:30:00|
|  1|223.104.41.121|2023-08-24 17:00:00|
|  2|223.104.41.122|2023-08-24 17:05:00|
|  3|223.104.41.103|2023-08-24 18:11:00|
|  2|223.104.41.103|2023-08-24 19:00:00|
|  1|223.104.41.104|2023-08-24 19:00:00|
|  3|223.104.41.122|2023-08