Introduction to SQL
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

NOT IN only.
Both IN and NOT IN.
IN only.
LIKE only.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
The order of occurrence determines the order of evaluation.
AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

ANSWER DOWNLOAD EXAMIANS APP