How would you write a SQL query using joins and aggregations to identify the top-performing tickers at Balyasny Asset Management?
Use the supplied ticker, desk, and PnL records. Consider finalized records from 2025 and retain tickers with at least two records.
ticker_symbol, asset_class, total_net_pnl, pnl_records, trading_days, and performance_rank.| Column | Type | Description |
|---|---|---|
| ticker_idPK | INT | Unique ticker identifier |
| ticker_symbol | VARCHAR(20) | Ticker symbol |
| asset_class | VARCHAR(30) | Asset classification |
| is_active | BOOLEAN | Whether the ticker is currently active |
| Column | Type | Description |
|---|---|---|
| desk_idPK | INT | Unique desk identifier |
| desk_name | VARCHAR(50) | Investment desk name |
| strategy | VARCHAR(40) | Desk investment strategy |
| Column | Type | Description |
|---|---|---|
| pnl_idPK | INT | Unique PnL record identifier |
| ticker_id | INT | Referenced ticker |
| desk_id | INT | Referenced investment desk |
| pnl_date | DATE | Date of the PnL record |
| net_pnl | NUMERIC(14,2) | Net profit or loss |
| status | VARCHAR(15) | Record finalization status |