Citi Interview Question

SQL question based on picking date in run time