Recently before attempting the question I read in TSQL fncdamental book that when query filters like WHERE, Having etc used then IN,BETWEEN, LIKE specified as Predicates....
I got correct answer and +1:-P:-D
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/