invece di

x between 5 and 7

usa

x>=5 and x<=7