SELECT ORIGIN_FROM_ADDRESS

FROM ETHEREUM.CORE.FACT_EVENT_LOGS

WHERE

contract_address = LOWER('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')

OR contract_address = LOWER('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')

OR contract_address = LOWER('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')

ORDER BY BLOCK_TIMESTAMP DESC

),

number_of_txs as (

SELECT ORIGIN_FROM_ADDRESS, COUNT(*) as nt

FROM ethereum.core.fact_transactions tx

RIGHT JOIN minters ON minters.ORIGIN_FROM_ADDRESS = tx.FROM_ADDRESS

GROUP BY 1

),

combined as (

SELECT

CASE

WHEN nt < 5 AND nt > 0 THEN 'first time (5 tx)'

WHEN nt > 1 AND nt <= 40 THEN 'average (< 40 txs)'

WHEN nt > 40 AND nt <= 200 THEN 'seasoned (< 200 txs)'

WHEN nt > 200 THEN 'veteran (> 200 txs)'

END as funder_type,

ORIGIN_FROM_ADDRESS,

nt as Total_Transactions

FROM number_of_txs

GROUP BY 1, ORIGIN_FROM_ADDRESS, nt

SELECT

funder_type,

COUNT(*) as num_instances

FROM combined

GROUP BY funder_type