with sweat_users as (
select
count(distinct(tx_signer)) as signers,
-- count(distinct(tx_hash)) as no_of_transactions
-- count(distinct(block_timestamp::date)) as date,
min(block_timestamp::date) as minimum_date
from near.core.fact_transactions
where tx_receiver = 'token.sweat'
and tx_status = 'Success'
)
select * from sweat_users