-- forked from Function Call - Method Name @ https://flipsidecrypto.xyz/edit/queries/f1a8b762-b6f8-4145-851b-ddeaa708bd25

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

with users as (

SELECT signer_id,

method_name,

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

SELECT *

FROM users

PIVOT(SUM(n_txns) FOR method_name IN ('add_project','edit_project','remove_project','verify_project','migrate_project','add_team','submit_application','approve_application'

,'reject_application','add_vendor','register_vendor','edit_vendor','remove_vendor','verify_vendor',

'add_proposal','edit_proposal','remove_proposal','reject_proposal','add_investors','register_investor','remove_investors','edit_investors',

'verify_investor','apply_for_program','add_request','edit_request','remove_request','add_contribution','accept_contribution','reject_contribution','remove_contribution','add_contributionAction',

'deliver_contribution','complete_contribution','give_vendor_feedback','give_project_feedback','add_claim','accept_claim','reject_claim'))

AS p

ORDER BY signer_id