Target interview question

SQL medium-advanced, Pyspark, Python coding