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