选项
A.
SELECT c#,cname FROM C WHERE teacher like '刘老师'
B.
SELECT c#,cname FROM C WHERE teacher='刘老师'
C.
SELECT c#,cname FROM C WHERE teacher like '刘%'
D.
SELECT c#,cname FROM S WHERE teacher like '刘老师'
正确答案：
名词解析
SELECT c#,cnameteacher FROM C WHERE teacher like '刘%'