Can we replace year > 1800 AND year < 1900 with BETWEEN 1800 AND 1900?

No, the operators would need to be >= and <= for that to be possibleYes, the two are equivalentNo, we can't use BETWEEN with numbers

No, the operators would need to be >= and <= for that to be possible.