Query editor
WITH filtered_trades AS (SELECT taker,MIN(blockchain) AS smallest_blockchain,SUM(amount_usd) AS total_amount_usdFROM kyberswap_aggregator.tradesGROUP BY takerHAVING SUM(amount_usd) > 10000000)SELECT taker AS address, smallest_blockchain, total_amount_usdFROM filtered_tradesORDER BY total_amount_usd DESC