Plum Healthcare interview question

SQL questions of basic joins and window functions.