First Republic interview question

Some questions based on your previous project, some coding problem on R, SQL.