Explain this query that counts active prompt template users.
Purpose: count users who opened or used a prompt template in the selected window. Join risk: events may duplicate users unless the query deduplicates by user id. Filter risk: locale and anonymous sessions may change the denominator. Performance: index event_name and created_at before running this on full history.
Chat Prompt
Recommended model: Claude Sonnet 5
SQL Query Explainer Chat
Use a structured chat workflow to explain a SQL query, assumptions, joins, and performance risks in plain language.
