Read as: customers who canceled in Q3 2026, divided by customers active on Jul 1, by plan
SELECT plan, COUNT(*) AS active_jul_1,COUNT_IF(canceled_on <= '2026-09-30') AS churned,DIV0(churned, active_jul_1) AS churn_rateFROM sales.customersWHERE started_on < '2026-07-01'AND (canceled_on IS NULL OR canceled_on >= '2026-07-01')GROUP BY plan;
Snowflake AI text to SQL with Snowflake Cortex Analyst
Cortex Analyst writes the SQL from your company’s Snowflake semantic view and says how it read your question. When your admin turns on the read-only SQL tool, Manus runs it and shows you the rows.