Sharing my experience with a HackerRank screening test.

There were two coding questions:

1. PySpark: This was a good question, and a very detailed implementation was asked for, using an autofill IDE (like VS Code).
2. SQL: This was also a good question, but there was a very huge problem with the output format. For example, they needed "0" as "0.00", but due to autofill formatting in the background, it wasn't reflecting correctly as "0.00". It was always converted to ".00", and because of that, my solution was not accepted. My entire logic was correct, but due to these types of silly issues, I was filtered out from the screening test.

Pyspark DataFrame transformations. SQL Window functions.