CREATE TABLE table_47626 ("Year" FLOAT, "Winner" CLOB, "Runners-up" CLOB, "Aggregate" CLOB, "1st leg" CLOB, "2nd leg" CLOB)

What was the 2nd leg for 2004?
SELECT "2nd leg" FROM table_47626 WHERE "Year" = '2004'
SELECT "2nd leg" FROM "table_47626" WHERE "Year" = '2004'