Write a SQL query to find the top three highest-performing collection portfolios based on total recovery amount at PRA Group.
Use the provided portfolio and recovery data. Include all portfolios in the comparison, including portfolios with no recovery records.
portfolio_name and total_recovery_amount.| Column | Type | Description |
|---|---|---|
| portfolio_idPK | INT | Unique identifier for the collection portfolio |
| portfolio_name | VARCHAR(100) | Name of the collection portfolio |
| Column | Type | Description |
|---|---|---|
| recovery_idPK | INT | Unique identifier for a recovery transaction |
| portfolio_id | INT | Portfolio associated with the recovery |
| recovery_date | DATE | Date the recovery was recorded |
| recovery_amount | NUMERIC(12,2) | Amount recovered from the account |