using a sql request in spark sql error in execution

admin

I try to execute this query in pyspark i get all the time error. I have looked everywhere but I don't know or it doesn't work if someone can help me. the goal of this…