initcap(PROJECT_NAME) AS PROJECTS,

COUNT(DISTINCT FROM_ADDRESS) AS users,

COUNT(DISTINCT TX_HASH) AS transactions,

SUM(TX_FEE) AS TOTAL_TXN_FEE,

AVG(TX_FEE) AS AVG_TXN_FEE,

TOTAL_TXN_FEE / users AS AVG_Fee_Per_User

FROM base.core.fact_transactions a

LEFT JOIN base.core.dim_labels b ON a.to_address = b.address

WHERE LABEL_TYPE NOT IN ('chadmin')

AND NOT project_name ilike any ('%Circle%', '%Tether%', '%Weth%')

AND b.project_name IS NOT NULL

AND a.status = 'SUCCESS'

GROUP BY b.project_name

ORDER BY users DESC

LIMIT 10