A. SELECT * FROM teacher WHERE 职称="教授" AND 职称="副教授"

B. SELECT * FROM teacher WHERE 职称 IN("教授", "副教授")

C. SELECT * FROM teacher WHERE 职称="教授" OR 职称="副教授"

D. SELECT * FROM teacher WHERE RIGHT(职称, 2)="教授"