HackerRank interview question

1. Pyspark data frame transformation. 2. SQL Window function.