=== Report 1: Pre-churn warning signs across sales, repeat buying, refunds, and support tickets (written by Grace) ===
Engineer's note: Repeat/refund rates are shown as percentages (0-100) for readability; refund rate numerator is restricted to refunds with status='succeeded' (reason as actually-completed refunds) and denominator is payments with a non-null captured_at in the window. Added a 12th column, total_churned_merchants, so the report states the full row count behind the 50-row cap as the handbook requires.
REPORT: Pre-churn warning signs across sales, repeat buying, refunds, and support tickets
QUESTION: In the months before a churned merchant's last order, did sales, shopper repeat-buying, refund rates, or support ticket volume already show warning signs?
merchant_name      | industry              | orders_final_90d | orders_prior_90d | revenue_growth_pct | repeat_rate_final_pct | repeat_rate_prior_pct | refund_rate_final_pct | refund_rate_prior_pct | tickets_final_90d | tickets_prior_90d | total_churned_merchants
-------------------+-----------------------+------------------+------------------+--------------------+-----------------------+-----------------------+-----------------------+-----------------------+-------------------+-------------------+------------------------
Paddock & Pine     | Apparel & Footwear    |                1 |                0 |               NULL |                   0.0 |                  NULL |                  NULL |                  NULL |                 0 |                 0 |                       9
Petal & Pestle     | Beauty                |                3 |                4 |               41.4 |                   0.0 |                  50.0 |                   0.0 |                   0.0 |                 0 |                 0 |                       9
Klara Beauty       | Beauty                |                3 |                0 |               NULL |                 100.0 |                  NULL |                   0.0 |                  NULL |                 0 |                 0 |                       9
Dewdrop Studio     | Beauty                |                3 |                0 |               NULL |                 100.0 |                  NULL |                   0.0 |                  NULL |                 0 |                 0 |                       9
Aurum & Ash        | Jewelry & Accessories |                4 |                2 |              280.1 |                  33.3 |                 100.0 |                   0.0 |                   0.0 |                 0 |                 0 |                       9
Halden Boots       | Apparel & Footwear    |                5 |                2 |              -57.6 |                 100.0 |                   0.0 |                   0.0 |                   0.0 |                 1 |                 0 |                       9
Marginalia         | Books & Stationery    |                5 |                1 |              117.2 |                  33.3 |                   0.0 |                   0.0 |                   0.0 |                 0 |                 1 |                       9
Northwire Audio    | Consumer Electronics  |                7 |                0 |               NULL |                 100.0 |                  NULL |                  21.3 |                  NULL |                 0 |                 0 |                       9
Saltmarsh Knitwear | Apparel & Footwear    |               11 |                3 |               73.5 |                  25.0 |                   0.0 |                  28.8 |                  13.1 |                 0 |                 1 |                       9
(9 rows)