Subject: 424-SQL---JOHN SMITH

1)

SQL> select count(playerid) as numplayers from playerinfo;

NUMPLAYERS
----------
        91


2)

SQL> select count(distinct playerid) as numplayers from hitting;

NUMPLAYERS
----------
        91


3)

SQL> select * from teams where teamid = 'NYA';

      YEAR TEA       WINS     LOSSES RUNSSCORED RUNSAGAINST
---------- --- ---------- ---------- ---------- -----------
TEAMNAME
--------------------------------------------------
      2002 NYA        103         58        897         697
New,York,Yankees

      2003 NYA        101         61        877         716
New,York,Yankees

      2004 NYA        101         61        897         808
New,York,Yankees