针对 数据库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 '_民%';