Examples for Business Question to SQL Translator

Calculates monthly churn rate segmented by subscription tier while excluding trial users who never activated. Demonstrates complex filtering logic, time series generation with generate_series, and proper churn rate formula (churned/active at month start).

Calculates cumulative revenue and customer count by week with same-week-last-year comparison. Demonstrates window functions for running totals (SUM OVER with PARTITION BY year), week number alignment for YoY comparison, and percentage change calculations with division-by-zero handling.

Calculates conversion rate from signup to first purchase, segmented by traffic source for last month. Demonstrates LEFT JOIN strategy to preserve non-converters in denominator, ROW_NUMBER for first purchase identification, and edge case handling for cancelled/refunded orders.