Who were the scorers in the semi-final round where oldham athletic were the opponents?
CREATE TABLE table_name_94 (scorers VARCHAR, opponents VARCHAR, round VARCHAR)
SELECT scorers FROM table_name_94 WHERE opponents = "oldham athletic" AND round = "semi-final"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (scorers VARCHAR, opponents VARCHAR, round VARCHAR) Question: Who were the scorers in the semi-final round where oldham athletic were the opponents? [/INST] SELECT scorers FROM table_name_94 WHERE opponents = "oldham athletic" AND round = "semi-final" </s>