ANSI-compliant. When using the "z BETWEEN x AND y" comparison, x must be less than or equal to y to return any matching values of z. It acts as "z>=x AND z<=y".
When using the "z BETWEEN x AND y" comparison, x and y are exchanged if x is greater than y.