范围与集合条件 — 信息技术选择题
题目
某气象站的 readings 表中，temp 为数值型字段，period 为字符型字段。现需筛选温度在 16 至 23（含端点）之间，且时段为“清晨”或“傍晚”的记录。下列 WHERE 子句正确的是（ ）
A. temp BETWEEN 16 AND 23 AND period IN ('清晨','傍晚')
B. temp BETWEEN 16 AND 23 OR period IN ('清晨','傍晚')
C. temp > 16 AND temp < 23 AND period IN ('清晨','傍晚')
D. temp BETWEEN 16 AND 23 AND period = '清晨' AND period = '傍晚'