Capgemini Interview Question

Writing Pyspark query along with its SQL query.