Which Tankers have a Hazmat of –, and Platforms of –, and a Staffing of volunteer?
CREATE TABLE table_name_9 (tankers VARCHAR, staffing VARCHAR, hazmat VARCHAR, platforms VARCHAR)
SELECT tankers FROM table_name_9 WHERE hazmat = "–" AND platforms = "–" AND staffing = "volunteer"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (tankers VARCHAR, staffing VARCHAR, hazmat VARCHAR, platforms VARCHAR) Question: Which Tankers have a Hazmat of –, and Platforms of –, and a Staffing of volunteer? [/INST] SELECT tankers FROM table_name_9 WHERE hazmat = "–" AND platforms = "–" AND staffing = "volunteer" </s>