Whenever you're ready, walk me through how you'd approach this.
How would you write SQL to analyze business performance across transactions, cohorts, and customer segments for Revolut? Explain how you would define the analytical grain, calculate meaningful metrics, compare cohorts over time, and segment customers without double-counting transactions. Discuss data quality, null handling, and query performance considerations.