l.project_name,

COUNT (DISTINCT t.tx_signer) AS users,

COUNT (DISTINCT t.tx_hash) AS transactions,

transactions/users AS tx_per_users,

sum (transaction_fee/ pow(10,24)) AS fees

FROM near.core.fact_transactions t JOIN near.core.dim_address_labels l

ON t.tx_receiver = l.address

WHERE tx_status = 'Success'

AND l1_label IS NULL

GROUP BY 1

HAVING project_name IS NOT NULL

ORDER BY 3 DESC

LIMIT 20