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:
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
SELECT count(*) AS Ordem, T2A.Y FROM T2 AS T2A GROUP BY T2A.Y ORDER BY Z
SELECT count(*) AS Ordem, T2.Y FROM T2 AS T2A WHERE T2.Y >= T2.Y GROUP BY Y ORDER BY count(*)
SELECT Ordem, Y FROM T2 GROUP BY Ordem ORDER BY Y
SELECT Ordem, T2.Y FROM T2 AS T2A, T2 AS T2B GROUP BY T2B.Y ORDER BY T2A.Y
Navegue em mais questões
{TITLE}
{CONTENT}