Capgemini Engineering Interview Question

Question on Joins, Optimizations based on Pyspark