SQL and Experiment Case Study

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

1. One row per experiment variant.
2. Include variant, assigned_users, converted_users, conversion_rate, total_orders, total_revenue, avg_order_value, lift_vs_control, and variant_rank.
3. Include variants with no orders, treat an assigned user with at least one order as converted, and sort by variant_rank, then variant.