Table: jets_patriots_games
Columns: year
date
winner
result
loser
location

Question: What is the name of the Loser when the winner was new england patriots, and a Location of giants stadium, and a Result of 30–28?
SQL: SELECT "loser" FROM jets_patriots_games WHERE "winner" = 'new england patriots' AND "location" = 'giants stadium' AND "result" = '30–28'

Question: What team was the lower when the winner was the new york jets, and a Year earlier than 1994, and a Result of 37–13?
SQL: SELECT "loser" FROM jets_patriots_games WHERE "winner" = 'new york jets' AND "year" < 1994 AND "result" = '37–13'

Question: What is the location when the new york jets lost earlier than 1997 and a Result of 31–28?
SQL: SELECT "location" FROM jets_patriots_games WHERE "loser" = 'new york jets' AND "year" < 1997 AND "result" = '31–28'

Question: What is the year when the Winner was the new york jets, with a Result of 24–17, played at giants stadium?
SQL: SELECT SUM("year") FROM jets_patriots_games WHERE "winner" = 'new york jets' AND "result" = '24–17' AND "location" = 'giants stadium'