Query editor
WITH ranked_addresses AS (SELECTblockchain,address,name,ROW_NUMBER() OVER (PARTITION BY address, blockchain ORDER BY LENGTH(name) DESC) AS rankFROM labels.addresses),ethereum_holders AS (SELECTo.rank,o.address,COALESCE(o.address_nametag, a.name) AS nametag,o.percentage,o.valueFROM dune.takeabreath.dataset_fdusd_ownership AS oLEFT JOIN ranked_addresses AS aON o.address = a.addressAND a.blockchain = 'ethereum'AND a.rank = 1),bnb_holders AS (SELECTo.rank,o.address,COALESCE(o.address_nametag, a.name) AS nametag,o.percentage,o.valueFROM dune.takeabreath.dataset_fdusd_ownership_bnb AS oLEFT JOIN ranked_addresses AS aON o.address = a.addressAND a.blockchain = 'bnb'AND a.rank = 1)SELECT * FROM ethereum_holders