human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Round, Opposition, First leg, Second leg, Aggregate score
###Question: What was the first leg of the semi-final?
gpt
SELECT First leg FROM table WHERE Round = semi-final