CREATE TABLE table_name_3 (number VARCHAR, inning VARCHAR, length VARCHAR)

What number home run was in the 8th inning and went 410'?
SELECT number FROM table_name_3 WHERE inning = "8th" AND length = "410'"
SELECT "number" FROM "table_name_3" WHERE "410'" = "length" AND "8th" = "inning"