Daily Withdrawal Limit Breach

The daily withdrawal limit is 1000. Return the account, date and total withdrawn for each day on which an account's total exceeded the limit.

Table schema

Withdrawals(id INT PRIMARY KEY, account_id INT, w_date DATE, amount INT)

Sample data

id | account_id | w_date | amount
1 | 1 | 2026-10-01 | 600
2 | 1 | 2026-10-01 | 500
3 | 2 | 2026-10-01 | 900