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.
customer_id, customer_name, account_type_count, and last_completed_transaction_date.customer_id ascending.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer full name |
| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique account identifier |
| customer_id | INT | Owning customer |
| account_type | VARCHAR(30) | Type of financial account |
| account_status | VARCHAR(20) | Current account status |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| account_id | INT | Account associated with the transaction |
| transaction_date | DATE | Date the transaction occurred |
| transaction_status | VARCHAR(20) | Processing status of the transaction |
| amount | NUMERIC(12,2) | Transaction amount |