code: def test_sql_is_between(foods_ipc_path: Path) -> None:
      lf = pl.scan_ipc(foods_ipc_path)
  
      ctx = pl.SQLContext(foods1=lf, eager_execution=True)
      out = ctx.execute(
          """
          SELECT *
          FROM foods1
          WHERE foods1.calories BETWEEN 22 AND 30
          ORDER BY "calories" DESC, "sugars_g" DESC
      """
      )
      assert out.rows() == [
          ("fruit", 30, 0.0, 5),
          ("vegetables", 30, 0.0, 5),
          ("fruit", 30, 0.0, 3),
          ("vegetables", 25, 0.0, 4),
          ("vegetables", 25, 0.0, 3),
          ("vegetables", 25, 0.0, 2),
          ("vegetables", 22, 0.0, 3),
      ]
      out = ctx.execute(
          """
          SELECT *
          FROM foods1
          WHERE calories NOT BETWEEN 22 AND 30
          ORDER BY "calories" ASC
          """
      )
      assert not any((22 <= cal <= 30) for cal in out["calories"])
  
imports: from __future__ import annotations
  import datetime
  import math
  from pathlib import Path
  import pytest
  import polars
  import polars.selectors
  from polars.exceptions import ComputeError, InvalidOperationError
  from polars.testing import assert_frame_equal, assert_series_equal
label_desc: Use image node_id 18 for calling a global function with example usage: test_sql_is_between(foods_ipc_path) without return types