Write SQL to flag suspect payments and chargebacks

For this question, assume the analysis date is 2025-10-15. Write a single SQL query that returns one row for every user who has at least one payment during the seven-day window [2025-10-08 00:00:00, 2025-10-15 00:00:00). The result must include these columns: user_id payments_last_7d — the number of that user's payments inside the seven-day window above. suspect_cnt_last_7d — how many of those same-window payments are classified as suspect. any_chargeback_last_60d — 'Y' if…