教师表teacher的“职称”字段可能的取值为:教授、副教授、讲师和助教要查找职称为教授或副教授的教师,错误的语句是()
A. SELECT * FROM teacher WHERE 职称=教授 AND 职称=副教授;
B. SELECT * FROM teacher WHERE RIGHT(职称, 2)=教授;
C. SELECT * FROM teacher WHERE 职称 IN(教授, 副教授);
D. SELECT * FROM teacher WHERE 职称=教授 OR 职称=副教授;