(

SELECT

TX_SENDER as address,

min(date(block_timestamp)) as first_date,

datediff('day', first_date, getdate())+1 as ages,

COUNT(address) AS tx_n

FROM terra.core.fact_transactions

GROUP BY 1

),

activity AS

(

SELECT

address,

case

WHEN tx_n BETWEEN 1 AND 10 THEN 'Under 10'

WHEN tx_n BETWEEN 10 AND 100 THEN 'Under 100'

WHEN tx_n BETWEEN 100 AND 500 THEN 'Under 500'

WHEN tx_n BETWEEN 500 AND 1000 THEN 'Under 1000'

ELSE 'Above 1000'

END AS activ,

tx_n

FROM wallets

WHERE ages<90

)

SELECT

activ,

COUNT (address) AS n_users,

sum(tx_n) AS n_tx

from activity

GROUP by 1