SELECT

COUNT(DISTINCT PROJECT_NAME) AS Total_Projects,

COUNT(DISTINCT LABEL_TYPE) AS Total_Sectors

FROM base.core.dim_labels

WHERE LABEL_TYPE NOT IN ('chadmin')

),

ActiveProjects AS (

SELECT

COUNT(DISTINCT b.PROJECT_NAME) AS Total_Active_Projects,

COUNT(DISTINCT b.LABEL_TYPE) AS Total_Active_Sectors

FROM base.core.fact_transactions a

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

WHERE a.BLOCK_TIMESTAMP::Date >= '2024-06-01'

AND LABEL_TYPE NOT IN ('chadmin')

SELECT

tp.Total_Projects,

tp.Total_Sectors,

ap.Total_Active_Projects,

ap.Total_Active_Sectors

FROM TotalProjects tp

CROSS JOIN ActiveProjects ap