题目链接：点击打开链接
题目大意：略。
解题思路：如图所示解决方案此类题必杀技。
AC 代码
WITH t1 AS(SELECT * FROM Logins GROUP BY id, login_date) SELECT DISTINCT t1_5.id, name FROM t1 t1_1 JOIN t1 t1_2 ON t1_1.id = t1_2.id AND DATEDIFF(t1_2.login_date, t1_1.login_date) = 1 JOIN t1 t1_3 ON t1_3.id = t1_2.id AND DATEDIFF(t1_3.login_date, t1_2.login_date) = 1 JOIN t1 t1_4 ON t1_4.id = t1_3.id AND DATEDIFF(t1_4.login_date, t1_3.login_date) = 1 JOIN t1 t1_5 ON t1_5.id = t1_4.id AND DATEDIFF(t1_5.login_date, t1_4.login_date) = 1 JOIN Accounts a ON a.id = t1_5.id ORDER BY t1_5.id
