Where clauses can use logical operators, comparison operators or arithmetic operators combined with parenthese to define complex conditions for queries. See RAQL
Operators for a complete list of valid operators for Where clauses.
This topic provides examples of many of the common techniques you can use:
Multiple Required Conditions