Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
Filtering by ranges is common: date windows, price bands, score thresholds. This question checks whether standard comparison operators suffice, or a special operator is mandatory.
Given Data / Assumptions:
Concept / Approach:
Ranges can be expressed directly: WHERE amount >= 100 AND amount < 200 or using BETWEEN (inclusive on both ends): WHERE amount BETWEEN 100 AND 200. Both approaches are valid; the choice depends on inclusivity needs and readability. These operators also work for temporal types (e.g., order_date >= DATE '2025-01-01' AND order_date < DATE '2025-02-01').
Step-by-Step Solution:
Verification / Alternative check:
Compare results of BETWEEN with explicit comparisons for off-by-one or end-of-day timestamp concerns. For timestamps, half-open intervals (>= start AND < next_start) are often safest.
Why Other Options Are Wrong:
Common Pitfalls:
Mishandling inclusivity, especially with timestamps—use half-open intervals to avoid missing late-night rows.
Final Answer:
Correct
Discussion & Comments