princefarzamHow much have users on Algorand spent on transactions in total?
    Updated 2022-07-03
    WITH All_txns AS (
    SELECT
    DISTINCT tx_id
    FROM flipside_prod_db.algorand.transactions
    WHERE BLOCK_TIMESTAMP >= '2022-01-01' --since Jan 2022
    )

    SELECT
    COUNT(DISTINCT SENDER) AS NUMBER_OF_USERS,
    COUNT(DISTINCT A.TX_ID) AS NUMBER_OF_TXNS,
    SUM(A.FEE) AS TOTAL_TXN_FEES_COST
    FROM flipside_prod_db.algorand.transactions A INNER JOIN All_txns B ON A.TX_ID= B.tx_id
    Run a query to Download Data