A SELECT aluno.codigo, aluno.nome FROM aluno INNER JOIN matricula ON aluno.id_aluno = matricula.id_aluno INNER JOIN disciplina ON disciplina.id_disciplina = matricula.id_disciplina WHERE disciplina.nome = 'FÍSICA' ORDER BY aluno.nome DESC, aluno.codigo DESC;
B SELECT aluno.codigo, aluno.nome FROM aluno INNER JOIN matricula ON aluno.id_aluno = matricula.id_aluno INNER JOIN disciplina ON disciplina.id_disciplina = matricula.id_disciplina WHERE disciplina.nome = 'FÍSICA' AND matricula.ano = 2016 AND matricula.periodo = 1 ORDER BY aluno.nome, aluno.codigo DESC;
C SELECT aluno.codigo, aluno.nome FROM aluno INNER JOIN matricula WHERE aluno.id_aluno = matricula.id_aluno INNER JOIN disciplina WHERE disciplina.id_disciplina = matricula.id_disciplina WHERE disciplina.nome = 'FÍSICA' AND matricula.ano = 2016 AND matricula.periodo = 1 ORDER BY aluno.nome DESC, aluno.codigo DESC;
D SELECT aluno.codigo, aluno.nome FROM aluno INNER JOIN matricula ON aluno.id_aluno = matricula.id_aluno INNER JOIN disciplina ON disciplina.id_disciplina = matricula.id_disciplina WHERE disciplina.nome = 'FÍSICA' AND matricula.ano = 2016 AND matricula.periodo = 1 ORDER BY aluno.nome DESC, aluno.codigo DESC;
E SELECT * FROM aluno INNER JOIN matricula ON aluno.id_aluno = matricula.id_aluno INNER JOIN disciplina ON disciplina.id_disciplina = matricula.id_disciplina WHERE disciplina.nome = 'FÍSICA' AND matricula.ano = 2016 and matricula.periodo = 1 ORDER BY aluno.nome DESC, aluno.codigo DESC;