Track Down SQL Errors

I'm having trouble with an SQL query that isn't working as expected. Here’s the query: [insert code]. What’s wrong with it?