Eka Care interview question

SQL joins and window functions and rolling sums