Query editor
WITH fnames AS (SELECTfid,ANY_VALUE(fname) AS fnameFROM dune.neynar.dataset_farcaster_fnamesWHERE deleted_at IS NULLGROUP BY fid),casts_unpacked AS (SELECTc.hash AS cast_hash,t.mention_fidFROM dune.neynar.dataset_farcaster_casts AS cCROSS JOIN UNNEST(c.mentions) AS t(mention_fid)WHERE c.deleted_at IS NULLAND c.timestamp >= NOW() - INTERVAL '7' DAY)SELECTu.mention_fid AS fid,f.fname,COUNT(DISTINCT u.cast_hash) AS unique_casts_with_mentionFROM casts_unpacked uLEFT JOIN fnames f ON f.fid = u.mention_fidGROUP BY 1, 2ORDER BY unique_casts_with_mention DESCLIMIT 10;