Table: football_rivalry
Columns: year
date
home_team
result
visiting_team
venue
attendance

Question: Who is the home team when the san francisco 49ers are visiting with a result of 42-14?
SQL: SELECT "home_team" FROM football_rivalry WHERE "visiting_team" = 'san francisco 49ers' AND "result" = '42-14'

Question: What was the total attendance for a result of 7-23 before 1960?
SQL: SELECT SUM("attendance") FROM football_rivalry WHERE "result" = '7-23' AND "year" < 1960