table: 1-1061075-1
columns: Season, Competition, Round, Opponents, 1st leg, 2nd leg, Aggregate
Q:  what's the competition where aggregate is 4–7
A: SELECT Competition FROM 1-1061075-1 WHERE Aggregate = '4–7'