Table: cardiff_football_0708
Columns: date
round
opponent
venue
result
attendance

Question: What opponent has final as the round?
SQL: SELECT "opponent" FROM cardiff_football_0708 WHERE "round" = 'final'

Question: What round has hereford united as the opponent?
SQL: SELECT "round" FROM cardiff_football_0708 WHERE "opponent" = 'hereford united'