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

Question: What was the venue in 1951 on November 4?
SQL: SELECT "venue" FROM football_rivalry WHERE "year" = 1951 AND "date" = 'november 4'

Question: What is the latest year with a 34-0 result?
SQL: SELECT MAX("year") FROM football_rivalry WHERE "result" = '34-0'

Question: What date was the visiting team of Los Angeles Rams, earlier than 1958?
SQL: SELECT "date" FROM football_rivalry WHERE "visiting_team" = 'los angeles rams' AND "year" < 1958

Question: What is the number in attendance at Los Angeles Memorial Coliseum?
SQL: SELECT COUNT("attendance") FROM football_rivalry WHERE "venue" = 'los angeles memorial coliseum'