范围与集合条件 — 信息技术选择题
题目
某校数据库的活动表中，时长字段duration以秒为单位，类型字段kind为字符型。现需查询时长不少于1分20秒且不超过2分钟，并且类型为“讲座”或“展演”的记录。下列WHERE子句正确的是（ ）
A. duration BETWEEN 80 AND 120 AND kind IN ('讲座','展演')
B. duration BETWEEN 80 AND 120 OR kind IN ('讲座','展演')
C. duration BETWEEN 80 AND 120 AND kind NOT IN ('讲座','展演')
D. duration BETWEEN 80 AND 120 AND kind = '讲座' AND kind = '展演'