Table: football_match_stats_4
Columns: date
opponent
venue
result
attendance

Question: what was the attendance for a home venue and a w 3-0 result?
SQL: SELECT AVG("attendance") FROM football_match_stats_4 WHERE "venue" = 'home' AND "result" = 'w 3-0'

Question: what was the attendance at the home venue with result w 3-1?
SQL: SELECT MAX("attendance") FROM football_match_stats_4 WHERE "venue" = 'home' AND "result" = 'w 3-1'

Question: where did rochdale play as opponent?
SQL: SELECT "venue" FROM football_match_stats_4 WHERE "opponent" = 'rochdale'