Query editor
SELECTuser_address,array_join(array_agg(DISTINCT CAST(source_chain_id AS VARCHAR)), '/') AS source_chains,array_join(array_agg(DISTINCT CAST(destination_chain_id AS VARCHAR)), '/') AS dest_chains,COUNT(DISTINCT source_chain_id) AS source_chain_count,COUNT(DISTINCT destination_chain_id) AS dest_chain_count,COUNT(*) AS transaction_count,SUM(amount_usd) AS total_volume,MAX(block_time) AS last_transaction_timeFROMlayerzero.sendWHEREsource_chain_id IS NOT NULLAND destination_chain_id IS NOT NULLGROUP BYuser_addressORDER BYtotal_volume DESC, transaction_count DESClimit 1000000