Query editor
WITHuni_airdrop_recipients as (SELECT"account" as recipients,"amount"/1e18 as amt_received,'\x1f9840a85d5af5bf1d1762f925bdaddc4201f984'::BYTEA as uni_token,'UNI' as uni_symbol,18 as uni_decimalsFROMuniswap."MerkleDistributor_evt_Claimed"ORDER BY 2 DESCLIMIT 100), -- Table with all the addresses that have claimed their UNI Airdrop. Ordered by amount received.recipients_ranked as (SELECTROW_NUMBER() OVER (ORDER BY ur.amt_received DESC) as "Rank",ur.recipients,'<a href=https://etherscan.io/address/0' || substring(ur.recipients::text from 2) || '/overview" target="_blank" >'|| COALESCE(min(lle.name), '0' || substring(ur.recipients::text from 2 for 5) || '...' || substring(ur.recipients::text from 39 for 4)) || '</a>' as "Top 100 Recipients",ur.amt_received as "$UNI Received"FROM uni_airdrop_recipients urLEFT JOIN ethereum."contracts" ec ON ur.recipients = ec.addressLEFT JOIN labels.labels lle ON ur.recipients = lle.address AND lle."type"='ens name reverse'AND ec.created_at IS NULLGROUP BY 2, 4) -- insert ens name and link to etherscan addressSELECT"Rank","Top 100 Recipients","$UNI Received"FROM recipients_ranked