HackerRank Interview Question

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