Write SQL to flag coordinated fake accounts

Assume the current date is 2025-09-01. The observation window is the seven-day span from 2025-08-26 00:00:00 through 2025-09-01 23:59:59, inclusive. You have six tables: users(user_id, created_at, country), logins(user_id, login_time, ip, country, device_id), friend_requests(sender_id, receiver_id, sent_time, accepted, accepted_time), messages(sender_id, receiver_id, sent_time), posts(post_id, user_id, created_time), and devices(device_id, user_id, device_type). For each…