-- forked from Function Call @ https://flipsidecrypto.xyz/edit/queries/36b029a9-4427-4d01-9a22-170ae9cc9cf1

SELECT signer_id,

method_name,

project_name,

label_type,

count(DISTINCT tx_hash) as n_txns

FROM near.core.fact_actions_events_function_call a

LEFT JOIN near.core.dim_address_labels b

on a.signer_id = b.address

WHERE receiver_id = 'nearhorizon.near'

GROUP BY 1,2,3,4

ORDER BY 1 DESC

SELECT DISTINCT method_name

FROM near.core.fact_actions_events_function_call

WHERE receiver_id = 'nearhorizon.near'