with

users_activities_raw as (

select

date_trunc(day, block_timestamp) as block_timestamp,

tx_signer as user,

project_name

from near.core.fact_transactions

inner join (select address, project_name from near.core.dim_address_labels

where label_type not in ('token','cex')

and label_subtype not in ('token_contract', 'nf_token_contract')

and project_name not in ('kaikai', 'sweat'))

on address = tx_receiver

where tx_succeeded=true

and tx_signer not in (select distinct address from near.core.dim_address_labels)

-- and block_timestamp::date >= '{{starting_date}}'

group by 1,2,3),

twoplusapp_users as (

select user

from (

select user,

count(distinct project_name) as projects

from users_activities_raw

group by user)

where projects>1

group by 1

),

users_activities as (

select a.* from users_activities_raw a

join twoplusapp_users b on a.user=b.user

),