Questão número 303795

Nas questões 51, 52, 53 considere as seguintes relações e suas instâncias.

Observe o seguinte resultado de uma consulta SQL sobre as relações dadas: O comando SQL utilizado deve ser:

• A.

  SELECT count(*) AS Ordem, T2A.Y FROM T2 AS T2A, T2 AS T2B WHERE T2A.Y >= T2B.Y GROUP BY T2A.Y ORDER BY 1

• B.

  SELECT count(*) AS Ordem, T2A.Y FROM T2 AS T2A GROUP BY T2A.Y ORDER BY Z

• C.

  SELECT count(*) AS Ordem, T2.Y FROM T2 AS T2A WHERE T2.Y >= T2.Y GROUP BY Y ORDER BY count(*)

• D.

  SELECT Ordem, Y FROM T2 GROUP BY Ordem ORDER BY Y

• E.

  SELECT Ordem, T2.Y FROM T2 AS T2A, T2 AS T2B GROUP BY T2B.Y ORDER BY T2A.Y