Query editor
WITH all_transfers AS (SELECTevt_tx_from AS wallet,COUNT(*) AS transaction_countFROM bonk_base.Bonk_evt_TransferGROUP BYevt_tx_fromUNION ALLSELECTevt_tx_to AS wallet,COUNT(*) AS transaction_countFROM bonk_base.Bonk_evt_TransferGROUP BYevt_tx_toUNION ALLSELECT"from" AS wallet,COUNT(*) AS transaction_countFROM bonk_ethereum.bonk_eth_evt_TransferGROUP BY"from"UNION ALLSELECT"to" AS wallet,COUNT(*) AS transaction_countFROM bonk_ethereum.bonk_eth_evt_TransferGROUP BY"to"UNION ALLSELECT"from" AS wallet,COUNT(*) AS transaction_countFROM bonkeytoken_bnb.BonkeyToken_evt_TransferGROUP BY"from"UNION ALLSELECT"to" AS wallet,COUNT(*) AS transaction_countFROM bonkeytoken_bnb.BonkeyToken_evt_TransferGROUP BY"to"UNION ALLSELECT"from" AS wallet,COUNT(*) AS transaction_countFROM bonki_ethereum.Bonki_evt_TransferGROUP BY"from"UNION ALLSELECT"to" AS wallet,COUNT(*) AS transaction_countFROM bonki_ethereum.Bonki_evt_TransferGROUP BY"to"), wallet_activity AS (SELECTwallet,SUM(transaction_count) AS total_transactions