This SQL tutorial explains the way of using the SQL BETWEEN Operator and the SQL NOT BETWEEN Operator to select data from a database table based on a given range.
Appreciate you sharing this article, but it is very SQL specific. Rather than discussing SQL as a language / tool / concept, it talks about a single operator - I think the former would be more relevant to the programming community.
IMO posts like this are best kept within the relevant community, or programming.dev will start filling up with cross-posts.