Ranges

between is the range-start keyword; and is the range-end keyword.

The following range is inclusive:
 where column1 between x and y
The following range is not inclusive:
 where column1 > x and column1 < y