user: ### NOW ANSWER:
Question: What was the first leg score against Real Sociedad?
Columns: ['Round', 'Opposition', 'First leg', 'Second leg', 'Aggregate score']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1st', 'Hibernian', '0–1 (a)', '3–1 (h)', '3–2']
SQL:

assistant: SELECT "First leg" FROM "Table" WHERE "Opposition" = 'Real Sociedad';