with sushiswaps as (
select tx_hash from ethereum_core.ez_dex_swaps
where platform = 'sushiswap' and block_timestamp::date >= '2022-05-07'
), swps as (
select distinct block_timestamp::date as day, from_address
from ethereum_core.fact_transactions
where tx_hash IN (select * from sushiswaps)
and block_timestamp::date >= '2022-05-07'
), final as (
select DISTINCT(from_address) as addresses, count(day) as days
from swps
group by 1
)
select DISTINCT(days), count(addresses)
from final
group by 1
order by 1 desc