signers[0]::string,

count(distinct(date_trunc('day', block_timestamp))) as sol_days,

'sol',

1 as numbering

from solana.fact_transactions

where block_timestamp >= '2022-01-01'

and succeeded = 'TRUE'

group by 1

having sol_days = 20),

eth as (select origin_from_address,

count(distinct(date_trunc('day', block_timestamp))) as eth_days,

'eth',

1 as numbering

from flipside_prod_db.ethereum_core.fact_event_logs

where block_timestamp >= '2022-01-01'

group by 1

having eth_days = 20

),

flow as (select proposer,

count(distinct(date_trunc('day', block_timestamp))) as flow_days,

'flow',

1 as numbering

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01'

group by 1

having flow_days = 20

)

select * from sol

select * from eth

union

select * from flow