What are the commissioned for scotts, greenock and chieftain?
CREATE TABLE table_1206583_2 (commissioned VARCHAR, builder VARCHAR, name VARCHAR)
SELECT commissioned FROM table_1206583_2 WHERE builder = "Scotts, Greenock" AND name = "Chieftain"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1206583_2 (commissioned VARCHAR, builder VARCHAR, name VARCHAR) Question: What are the commissioned for scotts, greenock and chieftain? [/INST] SELECT commissioned FROM table_1206583_2 WHERE builder = "Scotts, Greenock" AND name = "Chieftain" </s>