Boolean expression

Boolean expressions are allowed in WHERE clauses and in check
constraints. Boolean expressions in check constraints have limitations not
noted here; see CONSTRAINT clause for more information.
Boolean expressions in a WHERE clause have a highly liberal syntax; see WHERE clause, for example.

A boolean expression can include a boolean operator or operators.
These are listed in SQL Boolean Operators.

Tests whether the first operand is between the second and
third operands. The second operand must be less than the third operand. Applicable
only to types to which <= and >= can be applied.

WHERE booking_date BETWEEN
DATE('1998-02-26') AND
DATE('1998-03-01')

Expression [ NOT ]
BETWEEN Expression
AND Expression

IN

Operates on table subquery or list of values. Returns TRUE
if the left expression's value is in the result of the table subquery or in
the list of values. Table subquery can return multiple rows but must return
a single column.

WHERE booking_date NOT IN
(SELECT booking_date FROM
HotelBookings WHERE rooms_available = 0)

Operates on a table subquery. Returns TRUE if the table
subquery returns any rows, and FALSE if it returns no rows. Table subquery
can return multiple columns (only if you use * to denote multiple columns)
and rows.

A quantified comparison is a comparison operator (<,
=, >, <=, >=, <>) with ALL or ANY or SOME applied.

Operates
on table subqueries, which can return multiple rows but must return a single
column.

If ALL is used, the comparison must be true for all values
returned by the table subquery. If ANY or SOME is used, the comparison must
be true for at least one value of the table subquery. ANY and SOME are equivalent.