CASE WHEN lp_events < 5 THEN 'a Below 5 LP Events'

WHEN lp_events < 15 THEN 'b Between 5 - 15 LP Events'

WHEN lp_events < 25 THEN 'c Between 15 - 25 LP Events'

WHEN lp_events < 50 THEN 'd Between 25 - 50 LP Events'

WHEN lp_events < 100 THEN 'e Between 50 - 100 LP Events'

WHEN lp_events < 500 THEN 'f Between 100 - 500 LP Events'

ELSE 'g Over 500 LP Events' END as event_group,

count(*),

sum(lp_events)

FROM (

SELECT

LIQUIDITY_PROVIDER,

COUNT(DISTINCT tx_hash) as lp_events

FROM ethereum.uniswapv3.ez_lp_actions

WHERE block_timestamp > '2022-12-01'

GROUP BY 1

GROUP BY 1