DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE,

initcap(LABEL_TYPE) AS SECTOR,

COUNT(DISTINCT PROJECT_NAME) AS TOTAL_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

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 b.project_name IS NOT NULL

AND a.status = 'SUCCESS'

GROUP BY 1, 2

ORDER BY transactions DESC