What is the status with the opposing team of Scotland?
CREATE TABLE table_name_9 (status VARCHAR, opposing_teams VARCHAR)
SELECT status FROM table_name_9 WHERE opposing_teams = "scotland"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (status VARCHAR, opposing_teams VARCHAR) Question: What is the status with the opposing team of Scotland? [/INST] SELECT status FROM table_name_9 WHERE opposing_teams = "scotland" </s>