若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是

A．SELECT S#，SNAME FROM SWHERE SNAME‘李％’
B．SELECT S#，SNAME FROM SWHERE SNAME LIKE‘李％’
C．SELECT S#，SNAME FROM SWHERE SNAME=‘％李％’
D．SELECT S#，SNAME FROM SWHERE SNAME LIKE‘％李％’