– 6、查询“李“姓老师的数量

– 6、查询"李"姓老师的数量

SELECT 
COUNT(t.t_name)
FROM teacher t
GROUP BY 
t.t_name 
HAVING
t.t_name LIKE '李%'