14.d.    Get a list of all of the team names and the dates (ordered by date) that Dallas beat (ONLY) at home. 5 points.

 

SELECT teamname, gamedate

FROM team, game

WHERE hometeam = '1234'

AND htscore < vtscore

AND visitingteam = teamID

ORDER BY gamedate;

 

This yields the output:

 

TEAMNAME             GAMEDATE

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

Montreal                     14-JAN-01

Buffalo            04-FEB-01