What is the designation of material or non-material for either positional or automatic with no rectified count and either opponent?
CREATE TABLE table_name_36 (material_or_non_material VARCHAR, opponents VARCHAR, positional_or_automatic VARCHAR, count_rectified VARCHAR)
SELECT material_or_non_material FROM table_name_36 WHERE positional_or_automatic = "either" AND count_rectified = "no" AND opponents = "either"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_36 (material_or_non_material VARCHAR, opponents VARCHAR, positional_or_automatic VARCHAR, count_rectified VARCHAR) Question: What is the designation of material or non-material for either positional or automatic with no rectified count and either opponent? [/INST] SELECT material_or_non_material FROM table_name_36 WHERE positional_or_automatic = "either" AND count_rectified = "no" AND opponents = "either" </s>