-- Alumnos con salon
SELECT CONCAT(t4.titulo, ' ', t3.seccion),
    concat(t1.paterno,
              ' ',
              t1.materno,
              ', ',
              t1.nombres)
          AS alunomb
FROM alumno t1
    JOIN salonal t2 ON t1.codalu = t2.alucod
    JOIN salon t3 ON t2.salcod = t3.salcod
    JOIN grados t4 ON t3.nivel = t4.nivel AND t3.grado = t4.grado
WHERE t3.ano = '2019'
ORDER BY t4.ordenacade,
         t4.nivel,
         t4.orden,
         t3.seccion,
         alunomb;