题目链接：点击打开链接
题目大意：略。
解题思路：略。
AC 代码
WITH t AS(SELECT t.account_id, SUM(amount) total, MONTH(day) mon, max_income FROM Transactions t JOIN Accounts a USING(account_id) WHERE type = 'Creditor' GROUP BY 1, 3 HAVING total > max_income ORDER BY account_id, mon) SELECT DISTINCT account_id FROM t t1 WHERE (account_id, mon + 1) IN (SELECT account_id, mon FROM t WHERE account_id = t1.account_id)
