Describe how you would combine basic SQL joins and window functions with A/B testing to answer a case study question.
Use the supplied assignment, user, and order data. Calculate variant-level conversion and order metrics, compare each variant with control group A, and rank variants by conversion rate.
Output
- One row per experiment variant.
- Include
variant, assigned_users, converted_users, conversion_rate, total_orders, total_revenue, avg_order_value, lift_vs_control, and variant_rank.
- Include variants with no orders, treat an assigned user with at least one order as converted, and sort by
variant_rank, then variant.
