Answers






Answers

12.1

  1. ORDER BY 1

  2. ORDER BY PLAYERNO

  3. ORDER BY 1 ASC

  4. ORDER BY PLAYERNO ASC

12.2

  1. Correct.

  2. Incorrect because there is no twentieth column in the PLAYERS table.

  3. Incorrect because sorting is specified twice on the INITIALS column.

  4. Incorrect because a column in an ORDER BY clause cannot be specified twice.

12.3

SELECT   PLAYERNO, TEAMNO, WON - LOST
FROM     MATCHES
ORDER BY 3 ASC



 Python   SQL   Java   php   Perl 
 game development   web development   internet   *nix   graphics   hardware 
 telecommunications   C++ 
 Flash   Active Directory   Windows