我的SQL查询出了什么问题？

I need a quick look at my SQL query. It's already given me a headache. Comparing some advice I have gotten, I could not figure out the proper format for my SQL.I need a quick look at my SQL query. It's alrea