14c2.   Get a list (ordered by date played) of all games that ended in a tie.

 

      SELECT DISTINCT gamedate

      FROM game, team

      WHERE htscore = vtscore

      ORDER BY gamedate;

 

This yields the output:

 

      GAMEDATE

      ---------

      18-NOV-00

      30-DEC-00

      11-FEB-01

      14-MAR-01

      14-APR-01