You can specify a range of values that a column should satisfy using the BETWEEN predicate. Type the condition BETWEEN followed by a number, then the keyword AND, then another number. For example:
Between 2 and 8
