Eventbrite interview question

SQL aggregation question and other window function