Citi interview question

SQL question based on picking date in run time