Capgemini interview question

Writing Pyspark query along with its SQL query.