Does 80 make the cut?

Question

Accepted Answer

BETWEEN x AND y is exactly equivalent to col >= x AND col <= y - both boundary values are included. Bob (80) hits the lower boundary; Dave (100) hits the upper boundary; both qualify. A common mistake is assuming BETWEEN is exclusive, which would wrongly drop Bob and Dave.

id	student	score
1	Alice	70
2	Bob	80
3	Carol	90
4	Dave	100