SQL for Multiple Accounts No Recent Activity

How do you write SQL to identify customers with multiple account types and no recent transactions at PNC Financial Services Group? Assume only active accounts and completed transactions qualify. Treat the 90 days before April 1, 2025 as the recent period.

Output

1. One row per qualifying customer.
2. Include customer_id, customer_name, account_type_count, and last_completed_transaction_date.
3. Sort by customer_id ascending.

Output details

• Require at least two distinct active account types per customer.
• Treat the recent period as inclusive of 2025-01-01 and exclusive of 2025-04-01.
• Set last_completed_transaction_date to the latest completed transaction date on an active account, including dates outside the recent period.
• Retain customers with no completed transactions and return NULL for last_completed_transaction_date.