with t1 as (select 'Polygon' as network,
ORIGIN_FROM_ADDRESS as swapper,
count(distinct tx_hash) as n_swaps,
CASE WHEN n_swaps BETWEEN 1 AND 5 THEN '# swaps BETWEEN 1 AND 5'
WHEN n_swaps BETWEEN 5 AND 10 THEN '# swaps BETWEEN 5 AND 10'
WHEN n_swaps BETWEEN 10 AND 100 THEN '# swaps BETWEEN 10 AND 100'
ELSE ' # swaps is more than 100' END AS cat
from Polygon.core.fact_event_logs
where origin_to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57'
and event_name = 'Swap'
and block_timestamp >= CURRENT_DATE - 90
group by 2)
SELECT
cat,
COUNT(swapper)
FROM t1
GROUP BY 1