/*the BETWEEN operator is used to filter the result set within a certain range. the values can be numbers, texts or dates */ SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;