with deposits as (
select
origin_from_address,
count (distinct pool_address) as pool_count
from optimism.velodrome.ez_lp_actions
where lp_action = 'deposit'
and block_timestamp >= '2022-09-01'
group by origin_from_address
)
select
case
when pool_count = 1 then 'a. 1'
when pool_count > 1 and pool_count <= 10 then 'b. >1 to 10'
when pool_count > 10 then 'c. More than 10'
end as pool_bin,
count(origin_from_address )
from deposits
group by pool_bin