with w as(SELECT PROPOSER, count(distinct tx_id) as tx_counts from flow.core.fact_transactions where BLOCK_TIMESTAMP::date > current_date-90 GROUP by 1), w_12 as (SELECT case when tx_counts < 10 THEN '1-10' when tx_counts < 100 THEN '10-100' when tx_counts < 1000 THEN '100-1000' when tx_counts < 10000 THEN '1000-10,000' else 'more than 10,000' end as tx_range , count(*) as counts from w group by 1 order by 1), --------------------------------------------------------------------------------------------------------------------------------------- s as (SELECT SIGNERS[0] as wallet, count(distinct tx_id) as tx_counts from solana.core.fact_transactions where BLOCK_TIMESTAMP::date > current_date-90 GROUP by 1), s_12 as (SELECT case when tx_counts < 10 THEN '1-10' when tx_counts < 100 THEN '10-100' when tx_counts < 1000 THEN '100-1000' when tx_counts < 10000 THEN '1000-10,000' else 'more than 10,000' end as tx_range , count(*) as counts from s group by 1 order by 1), ------------------------------------------------------------------------------------------------------------------------------------ e as (SELECT FROM_ADDRESS as wallet, count(distinct tx_hash) as tx_counts from ethereum.core.fact_transactions where BLOCK_TIMESTAMP::date > current_date-90 GROUP by 1), e_12 as (SELECT case when tx_counts < 10 THEN '1-10' when tx_counts < 100 THEN '10-100' when tx_counts < 1000 THEN '100-1000' when tx_counts < 10000 THEN '1000-10,000' else 'more than 10,000' end as tx_range , count(*) as counts from e group by 1 order by 1) ------------------------------------------------------------------------- SELECT 'Flow' as chain, * from w_12 UNION SELECT 'solana' as chain,* from s_12 UNION SELECT 'Ethereum' as chain,* from e_12

Flow Users Retention- Recent Review