14.c.    Get A list of all of the Players (ordered by Player_Name) who played for the Buffalo Sabres (Team Name = ‘Buffalo’) in the year 2000 AND are still playing for them..

 

      SELECT playername, startdate

      FROM team, player, employs

      WHERE teamname = 'Buffalo'

      AND team.teamID = employs.teamID

      AND employs.playerID = player.playerID

      AND startdate < '01-JAN-2001'

      AND enddate IS NULL

      ORDER BY playername;

 

This yields the output:

 

PLAYERNAME        STARTDATE

-----------------------       ------------------

Hasek, D.                   19-NOV-94

Horton, T.                  25-SEP-93

Schoenfeld, J.           08-MAY-95