Table: eag_gia_rival
Columns: year
date
winner
result
location

Question: what is the location when the year is after 1974 and the date is september 19?
SQL: SELECT "location" FROM eag_gia_rival WHERE "year" > 1974 AND "date" = 'september 19'

Question: what is the location when the year is before 1979 and the result is 19-17?
SQL: SELECT "location" FROM eag_gia_rival WHERE "year" < 1979 AND "result" = '19-17'

Question: what is the result for 1970 at yankee stadium?
SQL: SELECT "result" FROM eag_gia_rival WHERE "year" = 1970 AND "location" = 'yankee stadium'

Question: what is the year when the location is yankee stadium and the result is 23-23
SQL: SELECT AVG("year") FROM eag_gia_rival WHERE "location" = 'yankee stadium' AND "result" = '23-23'