Petal Interview Question

SQL aggregation and window function questions applied to a certain dataset