CREATE TABLE table_name_41 (scorers VARCHAR2, venue VARCHAR2, opponent VARCHAR2)

Which Scorers have a Venue of A, and an Opponent of arsenal?
SELECT scorers FROM table_name_41 WHERE venue = "a" AND opponent = "arsenal"
SELECT "scorers" FROM "table_name_41" WHERE "a" = "venue" AND "arsenal" = "opponent"