Meta·Data Scientist·Online Assessment (OA)
- Given a multi-table schema (users, events, orders, payments, refunds), write a single SQL query that produces one row per signup cohort month for August 2025, reporting active users, payers, payer rate, and GMV. The query must handle invalid payments, same-month refunds that cancel out a payer, late payments landing outside the month, a NULL-safe denominator, and NULL user_ids.
“This one took me longer than I expected to outline before writing a single line.”