Table: partick_20072008_games
Columns: round
date
opponent
venue
attendance

Question: Who was the opponent at the qf(r) round?
SQL: SELECT "opponent" FROM partick_20072008_games WHERE "round" = 'qf(r)'

Question: What day was the game held at Firhill against AYR United?
SQL: SELECT "date" FROM partick_20072008_games WHERE "venue" = 'firhill' AND "opponent" = 'ayr united'

Question: What is the average attendance at a game held at Firhill for the 5(r) round?
SQL: SELECT AVG("attendance") FROM partick_20072008_games WHERE "venue" = 'firhill' AND "round" = '5(r)'