SELECT CONCAT (C.titulo,' tiene ', COUNT(A.apellidos),' alumnos') AS Info_profesores
FROM alumnos AS A,cursos AS C, alumnos_cursos AS AC
WHERE C.id_curso = AC.id_curso
AND A.id_alumno = AC.id_alumno
GROUP BY C.titulo
HAVING COUNT(a.apellidos) = 2