select a.rut, a.nombre, count(*) from alumnos a join atrasos s on (s.CampoTipo = a.CampoTipo and s.activo = 1) group by a.rut, a.nombre