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