Query editor
SELECTcex_name,blockchain,distinct_name,CASEWHEN blockchain IN ('bitcoin','tron','solana','sui','aptos') THEN from_utf8(address)ELSE CONCAT('0x', LOWER(to_hex(address)))END AS address,added_by,added_dateFROM cex.addressesWHERE cex_name IN ('Binance','Binance US','Bybit','Bitget','Gate.io','Gate','Gate_io','MEXC','mexc','KuCoin','kucoin','Crypto.com','Crypto_com','Bitfinex','bitfinex','BingX','Kraken','kraken','BitMart','LBank','Bitstamp','YoBit','Bitunix','CoinEx','Biconomy','DigiFinex','Bitkan','Phemex','CEX.IO')ORDER BY cex_name, blockchain