Pregunta de entrevista de Eventbrite

SQL aggregation question and other window function