Select join

"failed to parse select parameter (wallet_address,created_at,pnl_scoreASpnl_score,(SELECTpnl_scoreFROMscansASs2WHEREs2.wallet_address=scans.wallet_addressANDs2.created_at=scans.created_atANDs2.simulated=true)ASsimulated_pnl_score)" (line 1, column 48)'

const { data, error } = await supabase
  .from('scans')
  .select(`
    wallet_address,
    created_at,
    pnl_score AS pnl_score,
    (SELECT pnl_score FROM scans AS s2 
        WHERE s2.wallet_address = scans.wallet_address 
        AND s2.created_at = scans.created_at 
        AND s2.simulated = true
    ) AS simulated_pnl_score
  `)
  .eq('simulated', false);