select count(m.school_id) as sid，s.school_name，m.mat_namefrom school as sleft join mat as m on s.id = m.school_id闲的无聊，回答问题，手机手打，打错-_-||自己排错
