SELECT

DATE_TRUNC('month', block_timestamp) AS month,

COUNT(DISTINCT Authorizers[0]) AS Users

FROM

flow.core.fact_transactions

WHERE

block_timestamp::DATE >= '2024-01-01'

AND block_timestamp::DATE < '2024-08-01'

AND Tx_succeeded = 'True'

GROUP BY 1

Month,

Users,

LAG(Users) OVER (ORDER BY Month) AS Previous_month_users,

IFF(

((Users - LAG(Users) OVER (ORDER BY Month)) / LAG(Users) OVER (ORDER BY Month)) * 100 < 0,

0,

((Users - LAG(Users) OVER (ORDER BY Month)) / LAG(Users) OVER (ORDER BY Month)) * 100

) AS Users_diff

FROM Users_July

ORDER BY Month DESC