What is the code nickname where Steve Mayne is the coach?
CREATE TABLE table_18752986_1 (nickname VARCHAR, coach VARCHAR)
SELECT nickname FROM table_18752986_1 WHERE coach = "Steve Mayne"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_18752986_1 (nickname VARCHAR, coach VARCHAR) Question: What is the code nickname where Steve Mayne is the coach? [/INST] SELECT nickname FROM table_18752986_1 WHERE coach = "Steve Mayne" </s>