14.b2. Get A list of all Get A list of all of the Players (ordered by Player_Name) who have ever played for the Buffalo Sabres (Team Name = ‘Buffalo’)

 

      SELECT playername, startdate, enddate

      FROM team, player, employs

      WHERE teamname = 'Buffalo'

      AND team.teamID = employs.teamID

      AND employs.playerID = player.playerID

      ORDER BY playername;

 

This yields the output:

 

      PLAYERNAME              STARTDATE            ENDDATE

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

      Hasek, D.                         19-NOV-94

      Horton, T.                         25-SEP-93

      Martin, R.                        30-MAY-90                11-FEB-01

      Perot, G.                           09-NOV-84                 22-JUL-97

      Robert, R.                        29-MAR-01

      Schoenfeld, J.                 08-MAY-95

      Strudland, B.                    11-FEB-01

 

      7 rows selected.