Pregunta de entrevista de Testing

how to do CTE and window functions in SQL