What are all the states (class) when the reason for change was resigned November 26, 1798 and the vacator was John Hunter ( DR )?
CREATE TABLE table_224839_3 (state__class_ VARCHAR, reason_for_change VARCHAR, vacator VARCHAR)
SELECT state__class_ FROM table_224839_3 WHERE reason_for_change = "Resigned November 26, 1798" AND vacator = "John Hunter ( DR )"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_224839_3 (state__class_ VARCHAR, reason_for_change VARCHAR, vacator VARCHAR) Question: What are all the states (class) when the reason for change was resigned November 26, 1798 and the vacator was John Hunter ( DR )? [/INST] SELECT state__class_ FROM table_224839_3 WHERE reason_for_change = "Resigned November 26, 1798" AND vacator = "John Hunter ( DR )" </s>