CREATE TABLE table_72103 ("Season" CLOB, "Competition" CLOB, "Round" CLOB, "Opponents" CLOB, "1st leg" CLOB, "2nd leg" CLOB, "Aggregate" CLOB)

what's the competition where aggregate is 4 7
SELECT "Competition" FROM table_72103 WHERE "Aggregate" = '4–7'
SELECT "Competition" FROM "table_72103" WHERE "Aggregate" = '4–7'