with users as (
select
from_address,
count(fact_swaps_id) trades
from thorchain.defi.fact_swaps
group by 1
),
all_users as (
select
from_address,
trades,
case
when trades = 1 then '1'
when trades = 2 then '2'
when trades = 3 then '3'
when trades = 4 then '4'
when trades = 5 then '5'
when trades = 6 then '6'
when trades = 7 then '7'
when trades = 8 then '8'
when trades = 9 then '9'
when trades = 10 then '10'
when trades between 10 and 100 then '10 - 100'
when trades between 100 and 1000 then '100 - 1.000'
when trades between 1000 and 10000 then '1.000 - 10.000'
else '>10.000'
end typeuser
from users
)
select
typeuser as "Trades",
count(from_address) as "Users"