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

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