user: ### NOW ANSWER:
Question:  what's the competition where aggregate is 4–7
Columns: ['Season', 'Competition', 'Round', 'Opponents', '1st leg', '2nd leg', 'Aggregate']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1980-81', "UEFA Cup Winners' Cup", 'First round', 'Haugar', '1-1', '0-2', '1-3']
SQL:

assistant: SELECT "Competition" FROM "Table" WHERE "Aggregate" = '4–7';