MLDZMNhor5so
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with t1 as (SELECT
distinct SIGNER_ID as social_users
from near.social.fact_decoded_actions)
select
METHOD_NAME,
count(*) as no_usage
from near.horizon.fact_decoded_actions s
join near.core.dim_address_labels a on s.signer_id=a.address
WHERE args:account_id in (select social_users from t1)
group by 1
Run a query to Download Data