CREATE TABLE table_47124 ("Date" CLOB, "Location" CLOB, "Head coach" CLOB, "Opponent" CLOB, "Result" CLOB)

Who was the head coach when the opponent was Arsenal?
SELECT "Head coach" FROM table_47124 WHERE "Opponent" = 'arsenal'
SELECT "Head coach" FROM "table_47124" WHERE "Opponent" = 'arsenal'