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