liquidity_provider,

count(distinct tx_hash) as txns,

sum(nvl(amount0_usd, 0) + nvl(amount1_usd, 0)) as volume_usd,

count(distinct block_timestamp::date) as active_days

from ethereum.uniswapv3.ez_lp_actions

group by 1

when txns < 5 then 'a. Less than 5 Transactions'

when txns <= 10 then 'b. 5 - 10 Transactions'

when txns <= 25 then 'c. 10 - 25 Transactions'

when txns <= 50 then 'd. 25 - 50 Transactions'

when txns <= 100 then 'e. 50 - 100 Transactions'

else 'f. > 100 Transactions'

end as tx_type,

count(distinct liquidity_provider) as liquidity_providers

from tab1

group by 1

order by 1