Tredence Interview Question

SQL Self Joins, pyspark split and explode and group by aggregation