The SQL keyword BETWEEN is used:

The SQL keyword "BETWEEN" is used to define a range in SQL. It is typically used in the WHERE clause of a SELECT statement to filter rows based on a specified range of values.

The "BETWEEN" keyword is followed by two values, typically a lower and an upper bound, separated by the "AND" keyword. For example, you might use it to filter rows with values within a specific range, such as dates, numerical values, or text values.

When "BETWEEN" is used in a query, it helps limit the results to only those rows that fall within the specified range, making it a useful tool for filtering and retrieving data.

Therefore, the correct option is "Option B: for ranges," as the primary purpose of the "BETWEEN" keyword in SQL is to specify a range of values for filtering and querying data.