How would you use SQL to identify the top 10% of investors based on their total portfolio value at Prosper Marketplace?
Use the provided Prosper investor and portfolio position data. Include investors with no positions, treating their total portfolio value as zero.
investor_id, investor_name, total_portfolio_value, and portfolio_rank.portfolio_rank ascending, then investor_id ascending.| Column | Type | Description |
|---|---|---|
| investor_idPK | INT | Unique Prosper investor identifier |
| investor_name | VARCHAR(100) | Investor display name |
| Column | Type | Description |
|---|---|---|
| position_idPK | INT | Unique portfolio position identifier |
| investor_id | INT | Investor who owns the position |
| position_value | NUMERIC(14,2) | Current value of the portfolio position in dollars |