Um, again I'll chorus with the rest:

month(dob) in (1,2,3,4,5,8) - dob???? It doesn't exist, did you mean join_date? Sorry but you're wrong.

datename(m,join_date) like '%a%' - fair does, I cocked up Feb being february, a very sneaky question.