单项选择题
A.select count(*)from teacher where tname like ’李%’;B.select count(*)from teacher where tname like ’%李’;C.select count(*)from teacher where trim(tname)=’李%’;D.select count(*)from teacher where trim(tname)like ’%李’;
A.dropB.changeC.modifyD.rename
A.select sex,count(*)from student group by sexB.select sex,sum(*)from student group by sexC.select sex,sum(sex)from student group by sexD.select sex,count(sex)from student order by sex