查询姓张、姓王、姓刘老师的信息的方法是

A. SELECT *FROM TeacherWHERE Teachername like '张%' and Teachername like '王%' and Teachername like '刘%'
B. SELECT *FROM TeacherWHERE Teachername like '张%' or Teachername like '王%' and Teachername like '刘%'
C. SELECT *FROM TeacherWHERE Teachername like '张%' or Teachername like '王%' or Teachername like '刘%'
D. SELECT *FROM TeacherWHERE Teachername like '张%' and Teachername like '王%' or Teachername like '刘%'