SELECT --concat('https://etherscan.io/address/',

FROM_ADDRESS as user,

count(distinct tx_hash) as "Number of transactions"

FROM ethereum.core.fact_transactions

WHERE status = 'SUCCESS' AND to_address in ('0x31837aaf36961274a04b915697fdfca1af31a0c7', '0xf97e9727d8e7db7aa8f006d1742d107cf9411412',

'0x0a267cf51ef038fc00e71801f5a524aec06e4f07','0x2af4b707e1dce8fc345f38cfeeaa2421e54976d5','0xcdface5643b90ca4b3160dd2b5de80c1bf1cb088')

AND BLOCK_TIMESTAMP < '2022-04-15'

GROUP BY 1

HAVING "Number of transactions" >= 2

ORDER BY 2 desc),

df2 as (select

to_address as user_address,

raw_amount / pow(10,6) as amount

from ethereum.core.fact_token_transfers

where from_address = '0x8b799381ac40b838bba4131ffb26197c432afe78' and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and block_timestamp > '2022-11-21' and amount = 300

select

concat('https://etherscan.io/address/', user) as user

from df1 join df2 on df1.user = df2.user_address

where amount is not null