comparison operator can be used to specify a range of values as a search condition. When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as TRUE to be included in the query results. In a WHERE clause, logical operators are evaluated before comparison operators.
