Flipside TeamUsers Interaction Table
Updated 2024-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from Users Interaction Table @ https://flipsidecrypto.xyz/edit/queries/076e7ede-1db3-496b-afe2-e7ad39364acc
-- forked from graham / Base User Table @ https://flipsidecrypto.xyz/graham/q/lmxCVd7aq07A/base-user-table
select
tx_signer as "User Address",
count(distinct project_name) as "# of Projects",
array_agg(distinct project_name) as "Projects List"
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 blockchain = 'near')
on address = tx_receiver
where tx_succeeded=true
and tx_signer not in (select distinct address from near.core.dim_address_labels)
and year(block_timestamp) >= 2023
group by "User Address"
having "# of Projects" >= 2
QueryRunArchived: QueryRun has been archived