单项选择题

从无重复记录的teacher表中选出姓李的老师数量,下列语句正确的是()

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 ’%李’;