Capgemini Engineering interview question

Question on Joins, Optimizations based on Pyspark