Query editor
-- BearFAI Contract - Total ETH Sent by Each Address-- Contract: 0x6aa380BE99B944EC7f4693e1cE7c08E1376Db6bfSELECT"from" AS user_address,COUNT(*) AS num_transactions,SUM(value / 1e18) AS total_eth_sent,ROUND(SUM(value / 1e18) / 0.0033864 * 20, 0) AS total_tokens_receivedFROM ink.transactionsWHERE "to" = 0x6aa380BE99B944EC7f4693e1cE7c08E1376Db6bfAND value > 0GROUP BY "from"ORDER BY total_eth_sent DESC