Q. What does this query do?
Code:
SELECT name FROM students WHERE age BETWEEN 18 AND 22;
-
(A)
Selects students older than 18
-
(B)
Selects students younger than 22
-
(C)
Selects students aged exactly 18 and 22
-
(D)
Selects students aged between 18 and 22 inclusive
✅ Correct Answer: (D)
Selects students aged between 18 and 22 inclusive
Explanation: `BETWEEN` includes both boundary values: 18 and 22.