CREATE TABLE table_24887326_8 (away_team VARCHAR2, home_team VARCHAR2)

Who played as the away team when coventry city was the home team?
SELECT away_team FROM table_24887326_8 WHERE home_team = "Coventry City"
SELECT "away_team" FROM "table_24887326_8" WHERE "Coventry City" = "home_team"