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);
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);