![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
针对 数据库S_T, 查找student表中所有姓最后一个字是“民”的同学的学号,姓名,院系。
A.
select sno,sname,sdept from student where sname like '_民';
B.
select sno,sname,sdept from student where sname like '%民';
C.
select sno,sname,sdept from student where sname like '%民%';
D.
select sno,sname,sdept from student where sname like '_民%';