Introduction to SQL
A subquery in an SQL SELECT statement is enclosed in:

brackets -- [...].
CAPITAL LETTERS.
parenthesis -- (...) .
braces -- {...}.

ANSWER DOWNLOAD EXAMIANS APP

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

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.
NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
The order of occurrence determines the order of evaluation.

ANSWER DOWNLOAD EXAMIANS APP