Meta Interview Question

group by in SQL with window functions