题目链接:点击打开链接
题目大意:略。
解题思路:如图所示解决方案此类题必杀技。
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