Forward Financing interview question

Python focuses on writing functions on data processing; SQL is pretty easy, I used window functions. BQ: tell me a time type questions.