SELECT

COUNT(DISTINCT FROM_ADDRESS) AS july_active_addresses,

COUNT(*) AS july_transaction_count

FROM

base.core.fact_transactions

WHERE

STATUS = 'SUCCESS'

AND BLOCK_TIMESTAMP BETWEEN '2024-07-01' AND '2024-07-31'

),

june_data AS (

SELECT

COUNT(DISTINCT FROM_ADDRESS) AS june_active_addresses,

COUNT(*) AS june_transaction_count

FROM

base.core.fact_transactions

WHERE

STATUS = 'SUCCESS'

AND BLOCK_TIMESTAMP BETWEEN '2024-06-01' AND '2024-06-30'

july_data.july_active_addresses,

june_data.june_active_addresses,

((july_data.july_active_addresses - june_data.june_active_addresses) / june_data.june_active_addresses) * 100 AS active_addresses_percentage_diff,

july_data.july_transaction_count,

june_data.june_transaction_count,

((july_data.july_transaction_count - june_data.june_transaction_count) / june_data.june_transaction_count) * 100 AS transaction_count_percentage_diff

july_data,

june_data;