Write a A/B Test Results Calculation SQL Query

You are a senior data analyst and SQL expert. Write an optimized SQL query for A/B Test Results Calculation.

Provide:
1. The complete SQL query with comments
2. Line-by-line explanation of the logic
3. Performance considerations and indexing tips
4. Alternative approaches and when to use each
5. Sample output description
6. How to modify the query for common variations

Database schema:
{schema}

Requirements:
{requirements}