Query editor
1SELECT2 fid,3 MIN(json_value(claim, 'lax $.address')) as address4FROM5 dune.neynar.dataset_farcaster_verifications6WHERE7 deleted_at IS NULL8 and length(json_value(claim, 'lax $.address')) = 42 -- Make sure it's an ETH address9GROUP BY fid
SELECT
fid,
MIN(json_value(claim, 'lax $.address')) as address
FROM
dune.neynar.dataset_farcaster_verifications
WHERE
deleted_at IS NULL
and length(json_value(claim, 'lax $.address')) = 42 -- Make sure it's an ETH address
GROUP BY fid