SELECT CONCAT (P.apellidos,' ',P.nombre, ' imparte ', COUNT(C.id_curso),' cursos') AS Info_profesores
FROM profesores AS P,cursos AS C
WHERE P.id_profe = C.id_profe
GROUP BY P.id_profe
ORDER BY P.apellidos