sweat_receivers as (

tx_receiver,

min(block_timestamp) as first_reciept_date

from near.core.fact_transactions

where tx_status = 'Success'

and block_timestamp::date between '2022-05-01' and '2022-12-31'

and tx_signer = 'sweat_welcome.near'

group by 1

),

new_signers as (

SELECT

tx_signer,

min(block_timestamp) as first_signing_date

FROM near.core.fact_transactions

WHERE tx_status = 'Success'

AND block_timestamp::DATE >= '2022-09-01'

AND block_timestamp::DATE <= '2022-12-31'

and tx_signer in (select tx_receiver from sweat_receivers)

GROUP BY 1

from new_signers

limit 10