SELECT y FROM default WHERE x < 99;
Will get any documents that have x value as
boolean (true, false) or
x value < 99 .
Any documents that
x >= 99 or
string or
array or
object or
binary or
null or
MISSING field
will not get. same is true <= except equal value.
The value of y is irrelevant.
x <
99 means 99 value is not included, x <=
99 means 99 value included.