查询各班姓张有多少个人

class表

student表

查询各班姓张有多少人 要显示几班几个

select class_id,count(1) from `student`  WHERE NAME LIKE '张%'group by  class_id;

上面那个老哥应该写错表了..

直接查student表，根据班级分下组就行了

select class_id,count(1) from  student WHERE NAME LIKE '张%'group by  class_id;