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