Pregunta de entrevista de ZS Associates

Describe SQL joins and query based on window function