For queries, 'does not contain' evaluates blanks or fields without a value and results for classic queries and queries can be different. 

To make them equivalent do the following:

Example 1

I already have 'does not contain' in classic query and I want to modify the query to match.

• For classic query, use the AND [name] does not contain sunshine.
• For query, use AND ([name] does not contain sunshine AND [name] is not blank).

Example 2

I already have 'does not contain' in query and I want to modify the classic query to match.

• For classic query, use AND ([name] does not contain sunshine OR [name] is empty).
• For query, use AND [name] does not contain sunshine.