Pregunta de entrevista de Deloitte

What are window functions in SQL? Pandas codes to import dataset make changes and save the file again? Explaining your projects in detail.