Questões Militares Sobre banco de dados para quadro técnico

SELECT ID AS ORD, NOME

FROM ALUNO

SELECT ID AS ORD, NOME

FROM ALUNO

ORDER BY ID

SELECT COUNT(A2.ID) AS ORD, MIN(A1.NOME)AS

NOME

FROM ALUNO AS A1, ALUNO AS A2

WHERE A2.ID <= A1.ID

GROUP BY A1.ID

ORDER BY COUNT(A2.ID)

SELECT COUNT(A2.lD) AS ORD, A1.NOME

FROM ALUNO AS A1, ALUNO AS A2

WHERE A2.ID> A1.ID

GROUP BY A1.ID

ORDER BY COUNT(A2.ID)

SELECT COUNT(A2.ID) AS ORD, min(A1.NOME)

FROM ALUNO AS A1, ALUNO AS A2

WHERE A2.ID = A1.ID

GROUP BY A1.ID