b.label_type AS sector,

-- b.project_name,

COUNT(DISTINCT a.from_address) AS users,

COUNT(DISTINCT a.tx_hash) AS transactions

FROM base.core.fact_transactions a

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

WHERE b.label_type NOT IN ('token', 'chadmin')

AND b.label_type IS NOT NULL

AND b.project_name IS NOT NULL

AND a.status = 'SUCCESS'

GROUP BY 1

ORDER BY transactions DESC

LIMIT 20