The seasoned Zombie sniper: a query to find unanswered questions with specific tags
You have made a nice looking query here. I just have to nit-pick a little bit.  


You query the table Posts with a synonym q where I would expect p instead. I know you want to indicate that it is a question but nevertheless I would expect p instead of q.  
Every sql-statement is written in capital-letters but the AS keyword is written in lower-case-letters.


What you didn't take into account is the entering of a tag-synonym which would be  nice to have as well.