Eventbrite Interview Question

SQL aggregation question and other window function