CREATE TABLE table_12740 ("Home  ( 1st leg ) " CLOB, "Home  ( 2nd leg ) " CLOB, "1st Leg" CLOB, "2nd leg" CLOB, "Aggregate" CLOB)

What was the first leg home that had a total aggregate of 3-1?
SELECT "Home (1st leg)" FROM table_12740 WHERE "Aggregate" = '3-1'
SELECT "Home (1st leg)" FROM "table_12740" WHERE "Aggregate" = '3-1'