BETWEEN
When using the between operator, there are a couple of things to keep in mind. You should always specify the lower limit of the range first (after between) and the upper limit of the range second (after and)
use text() function from sqlalchemy to excute sql statement from pandas with %
- An expression can be null, but it can never equal null
- Two nulls are never equal to each other.