How can i get end balance

You can use integer value while using between operator.

AND balance BETWEEN 10 AND  100

You can typecast to integer and use in between operator. To deduce exact answer can you post actual dataset you are using.

---

Tech