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