Pregunta de entrevista de ABCXYZ

several window functions in SQL with bit complex queries. Spark performance tuning