Accenture interview question

From SQL majorly question Window function, CTE. In python simple python code & pyspark question like occurrence of word in a string...!