Tech Mahindra interview question

SQL join and window function, spark, adf