Pergunta de entrevista da empresa HSBC

simple SQL Query regarding date-time, groupby and min-max (it's a banking firm after all)