1mg Interview Question

sql window functions and some theory