SELECT date_Trunc('month',block_timestamp) as date,

count(DISTINCT project_name) as n_new_projects

FROM near.core.fact_transactions a

LEFT JOIN near.core.dim_address_labels b

ON a.tx_receiver = b.address

WHERE b.project_name IS NOT NULL

AND

date >= DATEADD('month', -1*{{last_n_month}}, CURRENT_DATE()-1)

GROUP BY 1

ORDER BY date DESC