with wallet as ( select trunc(block_timestamp,'day') as date, tx_receiver , deposit/pow(10,24) as near_amount from near.core.fact_Transfers where (tx_signer ilike '%sweat_welcome.near%' or tx_signer ilike '%sweat_oracle_%' ) and status = 'TRUE' and tx_receiver not in ('sweat_welcome.near')) , sweat_wallet as ( select tx_receiver from wallet where near_amount <= 0.05), ----- THIS PART OF CODE CREDITED TO PINEHEARST logs AS ( select block_timestamp, replace(value, 'EVENT_JSON:') as json, try_parse_json(json):event as event, regexp_substr(status_value, 'Success') as success, try_parse_json(json):data as data_logs from near.core.fact_receipts, table(flatten(input => logs)) where receiver_id = 'token.sweat' and success is not null and block_timestamp::date > '2022-09-12'), transfer as ( select block_timestamp, value:amount/pow(10,18) as amount, value:owner_id as owner_id, value:old_owner_id as old_owner_id, value:new_owner_id as new_owner_id, event, nvl(old_owner_id, 'mint') as from_address, nvl(new_owner_id, owner_id) as to_address from logs, table(flatten(input => data_logs)) where amount > 0 ) , final as ( select owner_id, sum(amount) as amounts, avg(amount) as average , median(amount) as median, max(amount) as max_amount, min(amount) as min_amount from transfer where event = 'ft_mint' and new_owner_id IS NULL and to_address IN (SELECT distinct tx_receiver FROM sweat_wallet) group by 1) select count(DISTINCT(owner_id)) as total, case when amounts > 0 and amounts < 1 then 'Up to 1 Sweat' when amounts >= 1 and amounts <= 2 then '1-2 Sweat' when amounts > 2 and amounts <= 5 then '3-5 Sweat' when amounts > 5 and amounts <= 10 then '6-10 Sweat' when amounts > 10 and amounts <= 15 then '11-15 Sweat' when amounts > 15 and amounts <= 20 then '16-20 Sweat' when amounts > 20 and amounts <= 25 then '21-25 Sweat' when amounts > 25 and amounts <= 35 then '26-35 Sweat' when amounts > 35 and amounts <= 50 then '36-50 Sweat' when amounts > 50 then '+50 Sweat' end as category from final group by 2

SWEAT In the Near Ecosystem