Jor-el2024-04-17 02:51 AM
    Updated 2024-04-17
    SELECT
    sender,
    COUNT(*) AS number_of_transactions,
    SUM(amount / POWER(10, decimal)) AS total_transferred
    FROM axelar.core.fact_transfers
    GROUP BY sender
    HAVING COUNT(*) > 10
    ORDER BY number_of_transactions DESC;

    QueryRunArchived: QueryRun has been archived