Domanda di colloquio di Citi

SQL question based on picking date in run time