Microsoft interview question

SQL Windows functions Advanced excel function