单项选择题
基于“学生—选课—课程”数据库中的三 个关系是：
S(S#,SNAME,SEX,AGE),SC(S#,C#,GRADE),C(C#,CNAME,TEACHER) 若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是______。
A．SELECT S#,SNAME FROM S WHERE SNAME=’李%’
B．SELECT S#,SNAME FROM S WHERE SNAME LIKE ’李%’
C．SELECT S#,SNAME FROM S WHERE SNAME=’%李%’
D．SELECT S#,SNAME FROM S WHERE SNAME LIKE ’%李%’
B．SELECT S#,SNAME FROM S WHERE SNAME LIKE ’李%’
C．SELECT S#,SNAME FROM S WHERE SNAME=’%李%’
D．SELECT S#,SNAME FROM S WHERE SNAME LIKE ’%李%’