Pregunta de entrevista de GoCardless

Basic sql questions like CTE and window function